PREVIEW / etf_1hour / 2008-06-19

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-06-19.parquet
  size:    106 KB
  rows:    3,386

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2008-06-19 04:00:00	SPY	ETF	133.96	134.3	133.96	134.22	2100.0
2008-06-19 05:00:00	SPY	ETF	134.29	134.32	134.22	134.22	1600.0
2008-06-19 06:00:00	SPY	ETF	134.23	134.27	134.23	134.24	6500.0
2008-06-19 07:00:00	SPY	ETF	134.24	134.58	134.2	134.55	649308.0
2008-06-19 08:00:00	SPY	ETF	134.54	134.63	134.23	134.29	4019659.0
2008-06-19 09:00:00	SPY	ETF	134.3	134.67	133.85	134.11	27654491.0
2008-06-19 10:00:00	SPY	ETF	134.12	134.45	133.55	134.36	49769546.0
2008-06-19 11:00:00	SPY	ETF	134.36	134.58	133.5	133.82	45156490.0
2008-06-19 12:00:00	SPY	ETF	133.82	134.57	133.75	134.22	46165413.0
2008-06-19 13:00:00	SPY	ETF	134.21	134.59	133.99	134.2	29047490.0
2008-06-19 14:00:00	SPY	ETF	134.2	135.04	133.97	134.96	40024291.0
2008-06-19 15:00:00	SPY	ETF	134.95	135.24	134.63	134.72	53276135.0
2008-06-19 16:00:00	SPY	ETF	134.68	134.69	134.25	134.52	5095188.0
2008-06-19 17:00:00	SPY	ETF	134.54	134.61	134.52	134.54	52583.0
2008-06-19 18:00:00	SPY	ETF	134.56	134.56	134.39	134.43	64650.0
2008-06-19 19:00:00	SPY	ETF	134.43	134.43	134.12	134.2	34875.0
2008-06-19 07:00:00	QQQ	ETF	47.97	48.08	47.97	48.08	142078.0
2008-06-19 08:00:00	QQQ	ETF	48.07	48.12	47.93	47.95	1205021.0
2008-06-19 09:00:00	QQQ	ETF	47.96	48.17	47.85	48.0	15765377.0
2008-06-19 10:00:00	QQQ	ETF	48.0	48.17	47.61	48.12	38725756.0
2008-06-19 11:00:00	QQQ	ETF	48.12	48.27	47.84	48.15	26590945.0
2008-06-19 12:00:00	QQQ	ETF	48.15	48.67	48.12	48.4422	37561112.0
2008-06-19 13:00:00	QQQ	ETF	48.44	48.65	48.38	48.49	12534420.0
2008-06-19 14:00:00	QQQ	ETF	48.49	49.0	48.39	48.9	29754539.0
2008-06-19 15:00:00	QQQ	ETF	48.9	49.01	48.71	48.79	27987683.0
2008-06-19 16:00:00	QQQ	ETF	48.79	48.83	48.0183	48.0183	10252023.0
2008-06-19 17:00:00	QQQ	ETF	48.8	48.85	48.8	48.8	104749.0
2008-06-19 18:00:00	QQQ	ETF	48.81	48.81	48.75	48.75	20107.0
2008-06-19 19:00:00	QQQ	ETF	48.75	48.75	48.69	48.7	42197.0
2008-06-19 07:00:00	IWM	ETF	73.15	73.28	73.13	73.21	95202.0
2008-06-19 08:00:00	IWM	ETF	73.25	73.39	73.1	73.23	417188.0
2008-06-19 09:00:00	IWM	ETF	73.16	73.41	72.89	73.09	10605497.0
2008-06-19 10:00:00	IWM	ETF	73.09	73.35	72.72	73.3	16069949.0
2008-06-19 11:00:00	IWM	ETF	73.31	73.55	72.77	72.99	12553554.0
2008-06-19 12:00:00	IWM	ETF	72.98	73.55	72.98	73.32	12010107.0
2008-06-19 13:00:00	IWM	ETF	73.31	73.45	73.13	73.23	9939723.0
2008-06-19 14:00:00	IWM	ETF	73.22	73.7	73.08	73.58	12518372.0
2008-06-19 15:00:00	IWM	ETF	73.57	73.78	73.38	73.78	19211816.0
2008-06-19 16:00:00	IWM	ETF	73.79	73.8	73.04	73.04	6451054.0
2008-06-19 17:00:00	IWM	ETF	73.71	73.9	73.71	73.9	15000.0
2008-06-19 18:00:00	IWM	ETF	73.74	73.74	73.64	73.7	7700.0
2008-06-19 19:00:00	IWM	ETF	73.73	73.78	73.69	73.69	600.0
2008-06-19 07:00:00	DIA	ETF	120.65	120.7	120.65	120.7	225.0
2008-06-19 08:00:00	DIA	ETF	120.82	120.88	120.58	120.58	84046.0
2008-06-19 09:00:00	DIA	ETF	120.59	120.85	120.11	120.37	2635170.0
2008-06-19 10:00:00	DIA	ETF	120.37	120.71	119.94	120.66	4351960.0
2008-06-19 11:00:00	DIA	ETF	120.67	120.86	119.99	120.22	3977561.0
2008-06-19 12:00:00	DIA	ETF	120.23	120.89	120.21	120.48	2764450.0
2008-06-19 13:00:00	DIA	ETF	120.48	120.8	120.21	120.38	1609011.0
2008-06-19 14:00:00	DIA	ETF	120.37	121.09	120.21	121.08	2270198.0

> showing 50 of 3,386 rows — these rows as CSV

> unlock the full archive -- $79 one-time