PREVIEW / etf_1hour / 2010-05-21

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-05-21.parquet
  size:    175 KB
  rows:    5,312

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
2010-05-21 04:00:00	SPY	ETF	108.06	108.25	107.88	108.0	7650.0
2010-05-21 05:00:00	SPY	ETF	107.89	108.25	107.6	107.82	68083.0
2010-05-21 06:00:00	SPY	ETF	107.7	107.91	106.9	107.2	132983.0
2010-05-21 07:00:00	SPY	ETF	107.14	107.35	106.26	106.87	3008323.0
2010-05-21 08:00:00	SPY	ETF	106.49	108.25	106.26	106.74	10255756.0
2010-05-21 09:00:00	SPY	ETF	106.74	108.1	105.64	107.72	106189326.0
2010-05-21 10:00:00	SPY	ETF	107.73	108.46	107.15	107.73	77123676.0
2010-05-21 11:00:00	SPY	ETF	107.72	109.38	107.54	109.04	68107580.0
2010-05-21 12:00:00	SPY	ETF	109.04	109.23	108.44	108.56	36364401.0
2010-05-21 13:00:00	SPY	ETF	108.56	108.85	108.17	108.75	30572626.0
2010-05-21 14:00:00	SPY	ETF	108.75	108.94	107.62	108.04	45714723.0
2010-05-21 15:00:00	SPY	ETF	108.04	109.18	107.3	109.1	97322390.0
2010-05-21 16:00:00	SPY	ETF	109.08	109.1221	106.61	108.97	23532745.0
2010-05-21 17:00:00	SPY	ETF	108.99	109.19	108.62	109.15	1075171.0
2010-05-21 18:00:00	SPY	ETF	109.15	109.33	109.03	109.29	201921.0
2010-05-21 19:00:00	SPY	ETF	109.29	109.35	109.22	109.28	81831.0
2010-05-21 04:00:00	QQQ	ETF	44.51	44.61	44.47	44.57	1808.0
2010-05-21 05:00:00	QQQ	ETF	44.6	44.6	44.42	44.42	20300.0
2010-05-21 06:00:00	QQQ	ETF	44.4	44.4	44.15	44.2	52358.0
2010-05-21 07:00:00	QQQ	ETF	44.24	44.28	43.76	44.02	319017.0
2010-05-21 08:00:00	QQQ	ETF	44.06	44.6	43.79	44.01	1218270.0
2010-05-21 09:00:00	QQQ	ETF	44.0	44.68	43.49	44.42	44326622.0
2010-05-21 10:00:00	QQQ	ETF	44.42	44.68	44.16	44.46	31695071.0
2010-05-21 11:00:00	QQQ	ETF	44.4501	45.17	44.43	44.99	21622188.0
2010-05-21 12:00:00	QQQ	ETF	44.99	45.15	44.76	44.81	14096052.0
2010-05-21 13:00:00	QQQ	ETF	44.81	45.0168	44.635	44.84	11621207.0
2010-05-21 14:00:00	QQQ	ETF	44.845	44.91	44.34	44.48	13779330.0
2010-05-21 15:00:00	QQQ	ETF	44.47	44.8501	44.23	44.85	30984804.0
2010-05-21 16:00:00	QQQ	ETF	44.84	45.0168	43.5233	44.78	5908147.0
2010-05-21 17:00:00	QQQ	ETF	44.77	44.82	44.73	44.82	44592.0
2010-05-21 18:00:00	QQQ	ETF	44.82	44.88	44.82	44.88	67081.0
2010-05-21 19:00:00	QQQ	ETF	44.88	44.94	44.87	44.93	42252.0
2010-05-21 06:00:00	IWM	ETF	63.74	63.74	63.7	63.7	1800.0
2010-05-21 07:00:00	IWM	ETF	63.7	63.82	63.15	63.42	255970.0
2010-05-21 08:00:00	IWM	ETF	63.47	64.29	63.13	63.41	2451960.0
2010-05-21 09:00:00	IWM	ETF	63.4	64.689	62.76	64.27	26025939.0
2010-05-21 10:00:00	IWM	ETF	64.27	64.6	63.63	64.1262	27924956.0
2010-05-21 11:00:00	IWM	ETF	64.12	65.64	64.06	65.27	19863744.0
2010-05-21 12:00:00	IWM	ETF	65.27	65.535	64.9	64.92	9290174.0
2010-05-21 13:00:00	IWM	ETF	64.92	65.07	64.58	64.9	6096406.0
2010-05-21 14:00:00	IWM	ETF	64.9	65.07	64.16	64.41	11193086.0
2010-05-21 15:00:00	IWM	ETF	64.4	65.1	64.0	65.1	24575889.0
2010-05-21 16:00:00	IWM	ETF	65.08	65.4	63.05	65.1	7290208.0
2010-05-21 17:00:00	IWM	ETF	65.11	65.24	65.1	65.22	123171.0
2010-05-21 18:00:00	IWM	ETF	65.2	65.27	65.07	65.2	108949.0
2010-05-21 19:00:00	IWM	ETF	65.2	65.24	65.16	65.23	8865.0
2010-05-21 07:00:00	DIA	ETF	100.54	100.54	99.78	100.17	14605.0
2010-05-21 08:00:00	DIA	ETF	100.19	100.21	99.7	99.95	98209.0
2010-05-21 09:00:00	DIA	ETF	99.89	100.89	99.02	100.57	5602530.0
2010-05-21 10:00:00	DIA	ETF	100.55	101.1	100.08	100.63	5588818.0

> showing 50 of 5,312 rows — these rows as CSV

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