PREVIEW / etf_1hour / 2012-04-30

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-04-30.parquet
  size:    180 KB
  rows:    5,675

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
2012-04-30 04:00:00	SPY	ETF	140.38	140.38	140.26	140.26	1800.0
2012-04-30 05:00:00	SPY	ETF	140.2	140.28	140.2	140.23	1200.0
2012-04-30 06:00:00	SPY	ETF	140.14	140.26	140.13	140.25	3400.0
2012-04-30 07:00:00	SPY	ETF	140.23	140.28	139.96	139.98	962954.0
2012-04-30 08:00:00	SPY	ETF	139.99	140.15	139.89	140.1	2021083.0
2012-04-30 09:00:00	SPY	ETF	140.12	140.21	139.65	139.73	22413105.0
2012-04-30 10:00:00	SPY	ETF	139.73	140.06	139.61	139.7191	19996436.0
2012-04-30 11:00:00	SPY	ETF	139.71	139.85	139.64	139.82	9892929.0
2012-04-30 12:00:00	SPY	ETF	139.83	139.87	139.69	139.77	6681547.0
2012-04-30 13:00:00	SPY	ETF	139.78	139.85	139.64	139.75	5690592.0
2012-04-30 14:00:00	SPY	ETF	139.75	139.79	139.49	139.65	9515421.0
2012-04-30 15:00:00	SPY	ETF	139.65	139.92	139.62	139.82	20792841.0
2012-04-30 16:00:00	SPY	ETF	139.8	140.06	139.71	140.06	7538734.0
2012-04-30 17:00:00	SPY	ETF	140.05	140.05	139.96	140.04	208277.0
2012-04-30 18:00:00	SPY	ETF	140.02	140.06	140.01	140.03	40081.0
2012-04-30 19:00:00	SPY	ETF	140.04	140.07	140.01	140.07	45832.0
2012-04-30 05:00:00	QQQ	ETF	67.24	67.24	67.17	67.17	200.0
2012-04-30 06:00:00	QQQ	ETF	67.15	67.2	67.15	67.2	12200.0
2012-04-30 07:00:00	QQQ	ETF	67.2	67.2	66.96	66.96	245337.0
2012-04-30 08:00:00	QQQ	ETF	66.97	67.07	66.94	67.06	1312801.0
2012-04-30 09:00:00	QQQ	ETF	67.06	67.17	66.79	66.84	10205642.0
2012-04-30 10:00:00	QQQ	ETF	66.83	66.96	66.74	66.89	5554735.0
2012-04-30 11:00:00	QQQ	ETF	66.885	66.98	66.75	66.98	3719966.0
2012-04-30 12:00:00	QQQ	ETF	66.975	66.98	66.81	66.87	2382906.0
2012-04-30 13:00:00	QQQ	ETF	66.8687	66.91	66.8	66.91	2026559.0
2012-04-30 14:00:00	QQQ	ETF	66.91	66.92	66.71	66.76	3311731.0
2012-04-30 15:00:00	QQQ	ETF	66.76	66.86	66.715	66.78	5869386.0
2012-04-30 16:00:00	QQQ	ETF	66.77	66.84	66.71	66.83	599254.0
2012-04-30 17:00:00	QQQ	ETF	66.83	66.85	66.77	66.84	14244.0
2012-04-30 18:00:00	QQQ	ETF	66.81	66.84	66.81	66.81	18301.0
2012-04-30 19:00:00	QQQ	ETF	66.82	66.83	66.82	66.83	4600.0
2012-04-30 07:00:00	IWM	ETF	82.35	82.35	82.24	82.24	9698.0
2012-04-30 08:00:00	IWM	ETF	82.23	82.33	82.13	82.33	155851.0
2012-04-30 09:00:00	IWM	ETF	82.33	82.43	81.61	81.687	6436604.0
2012-04-30 10:00:00	IWM	ETF	81.69	81.94	81.54	81.7225	6770903.0
2012-04-30 11:00:00	IWM	ETF	81.72	81.83	81.53	81.715	2767413.0
2012-04-30 12:00:00	IWM	ETF	81.72	81.73	81.5	81.66	2162248.0
2012-04-30 13:00:00	IWM	ETF	81.66	81.7	81.52	81.635	2579954.0
2012-04-30 14:00:00	IWM	ETF	81.64	81.69	81.47	81.61	3157334.0
2012-04-30 15:00:00	IWM	ETF	81.605	81.84	81.48	81.49	6712855.0
2012-04-30 16:00:00	IWM	ETF	81.49	81.66	81.43	81.62	2259807.0
2012-04-30 17:00:00	IWM	ETF	81.62	81.64	81.58	81.63	42102.0
2012-04-30 18:00:00	IWM	ETF	81.62	81.62	81.62	81.62	1000.0
2012-04-30 19:00:00	IWM	ETF	81.63	81.63	81.56	81.62	2000.0
2012-04-30 07:00:00	DIA	ETF	131.75	131.75	131.75	131.75	100.0
2012-04-30 08:00:00	DIA	ETF	131.75	131.86	131.65	131.84	68550.0
2012-04-30 09:00:00	DIA	ETF	131.85	132.02	131.64	131.6876	926722.0
2012-04-30 10:00:00	DIA	ETF	131.7053	132.02	131.62	131.66	664386.0
2012-04-30 11:00:00	DIA	ETF	131.67	131.76	131.58	131.74	345254.0
2012-04-30 12:00:00	DIA	ETF	131.74	131.78	131.635	131.71	296680.0

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

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