PREVIEW / etf_1hour / 2009-05-29

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-05-29.parquet
  size:    138 KB
  rows:    4,275

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
2009-05-29 04:00:00	SPY	ETF	91.24	91.33	91.24	91.33	800.0
2009-05-29 05:00:00	SPY	ETF	91.33	91.49	91.24	91.49	7818.0
2009-05-29 06:00:00	SPY	ETF	91.48	91.63	91.41	91.63	21100.0
2009-05-29 07:00:00	SPY	ETF	91.6	91.81	91.56	91.57	439042.0
2009-05-29 08:00:00	SPY	ETF	91.55	91.66	91.28	91.39	2334020.0
2009-05-29 09:00:00	SPY	ETF	91.39	91.68	90.68	91.14	42554115.0
2009-05-29 10:00:00	SPY	ETF	91.14	91.62	90.9	91.325	36076397.0
2009-05-29 11:00:00	SPY	ETF	91.32	91.4	90.81	90.89	31227568.0
2009-05-29 12:00:00	SPY	ETF	90.89	91.3	90.885	91.08	16008907.0
2009-05-29 13:00:00	SPY	ETF	91.08	91.45	91.07	91.3	15027161.0
2009-05-29 14:00:00	SPY	ETF	91.3	91.45	90.81	91.05	19028255.0
2009-05-29 15:00:00	SPY	ETF	91.05	92.69	90.96	92.65	51956705.0
2009-05-29 16:00:00	SPY	ETF	92.65	93.17	91.0453	92.55	38198951.0
2009-05-29 17:00:00	SPY	ETF	92.54	92.66	92.48	92.57	2597664.0
2009-05-29 18:00:00	SPY	ETF	92.58	92.6	92.37	92.41	174970.0
2009-05-29 19:00:00	SPY	ETF	92.42	92.47	92.27	92.47	160525.0
2009-05-29 04:00:00	QQQ	ETF	35.06	35.09	35.06	35.09	400.0
2009-05-29 05:00:00	QQQ	ETF	35.09	35.12	35.09	35.12	3000.0
2009-05-29 06:00:00	QQQ	ETF	35.08	35.17	35.07	35.17	4959.0
2009-05-29 07:00:00	QQQ	ETF	35.17	35.33	35.15	35.16	216496.0
2009-05-29 08:00:00	QQQ	ETF	35.16	35.17	34.99	35.0	787830.0
2009-05-29 09:00:00	QQQ	ETF	35.01	35.25	34.8385	35.03	24604356.0
2009-05-29 10:00:00	QQQ	ETF	35.02	35.14	34.94	35.03	13725728.0
2009-05-29 11:00:00	QQQ	ETF	35.03	35.08	34.76	34.79	15250160.0
2009-05-29 12:00:00	QQQ	ETF	34.79	34.94	34.79	34.83	8429478.0
2009-05-29 13:00:00	QQQ	ETF	34.83	35.02	34.83	34.95	5377428.0
2009-05-29 14:00:00	QQQ	ETF	34.95	35.02	34.78	34.88	6061982.0
2009-05-29 15:00:00	QQQ	ETF	34.87	35.4	34.84	35.4	20773429.0
2009-05-29 16:00:00	QQQ	ETF	35.4	35.5	34.9523	35.45	10360764.0
2009-05-29 17:00:00	QQQ	ETF	35.45	35.45	35.39	35.43	129222.0
2009-05-29 18:00:00	QQQ	ETF	35.42	35.45	35.42	35.42	24533.0
2009-05-29 19:00:00	QQQ	ETF	35.42	35.42	35.38	35.39	35840.0
2009-05-29 06:00:00	IWM	ETF	49.51	49.6	49.51	49.6	1080.0
2009-05-29 07:00:00	IWM	ETF	49.6	49.74	49.56	49.6	63699.0
2009-05-29 08:00:00	IWM	ETF	49.59	49.73	49.35	49.43	377159.0
2009-05-29 09:00:00	IWM	ETF	49.44	49.7	49.08	49.44	7020571.0
2009-05-29 10:00:00	IWM	ETF	49.45	49.79	49.32	49.6	7352728.0
2009-05-29 11:00:00	IWM	ETF	49.5999	49.66	49.16	49.22	6206077.0
2009-05-29 12:00:00	IWM	ETF	49.23	49.54	49.215	49.49	3824296.0
2009-05-29 13:00:00	IWM	ETF	49.5	49.76	49.49	49.6	3083703.0
2009-05-29 14:00:00	IWM	ETF	49.6	49.71	49.37	49.51	2988415.0
2009-05-29 15:00:00	IWM	ETF	49.51	50.22	49.44	50.22	11871041.0
2009-05-29 16:00:00	IWM	ETF	50.22	50.49	49.5924	50.31	6588969.0
2009-05-29 17:00:00	IWM	ETF	50.3	50.33	50.27	50.28	5024.0
2009-05-29 18:00:00	IWM	ETF	50.27	50.27	50.25	50.27	2100.0
2009-05-29 19:00:00	IWM	ETF	50.27	50.27	50.18	50.18	6800.0
2009-05-29 05:00:00	DIA	ETF	84.3	84.3	84.3	84.3	100.0
2009-05-29 06:00:00	DIA	ETF	84.5	84.6	84.5	84.6	200.0
2009-05-29 07:00:00	DIA	ETF	84.56	84.74	84.53	84.53	3200.0
2009-05-29 08:00:00	DIA	ETF	84.56	84.64	84.33	84.39	45019.0

> showing 50 of 4,275 rows — these rows as CSV

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