PREVIEW / etf_1hour / 2012-01-03

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-01-03.parquet
  size:    190 KB
  rows:    5,924

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-01-03 04:00:00	SPY	ETF	128.3	128.58	128.1	128.51	262895.0
2012-01-03 05:00:00	SPY	ETF	128.55	128.6	128.14	128.25	69334.0
2012-01-03 06:00:00	SPY	ETF	128.1	128.24	127.8	127.9	310120.0
2012-01-03 07:00:00	SPY	ETF	127.96	127.98	127.52	127.59	628121.0
2012-01-03 08:00:00	SPY	ETF	127.57	128.2	125.5	127.7	1346900.0
2012-01-03 09:00:00	SPY	ETF	127.7	128.12	127.67	127.93	21856577.0
2012-01-03 10:00:00	SPY	ETF	127.93	128.38	127.83	128.22	25660068.0
2012-01-03 11:00:00	SPY	ETF	128.22	128.34	127.9	127.95	15642032.0
2012-01-03 12:00:00	SPY	ETF	127.95	127.98	127.43	127.529	22823781.0
2012-01-03 13:00:00	SPY	ETF	127.54	127.8308	127.47	127.705	17460321.0
2012-01-03 14:00:00	SPY	ETF	127.71	128.07	127.67	128.05	18882381.0
2012-01-03 15:00:00	SPY	ETF	128.05	128.06	127.48	127.59	32791586.0
2012-01-03 16:00:00	SPY	ETF	127.58	128.265	125.6613	127.73	25487329.0
2012-01-03 17:00:00	SPY	ETF	127.73	127.78	127.67	127.72	143895.0
2012-01-03 18:00:00	SPY	ETF	127.71	127.76	127.49	127.67	287674.0
2012-01-03 19:00:00	SPY	ETF	127.66	127.73	127.62	127.65	102040.0
2012-01-03 04:00:00	QQQ	ETF	56.76	57.05	56.76	57.05	1800.0
2012-01-03 06:00:00	QQQ	ETF	56.75	56.95	56.75	56.95	4542.0
2012-01-03 07:00:00	QQQ	ETF	56.96	57.0	56.79	56.81	62979.0
2012-01-03 08:00:00	QQQ	ETF	56.8	56.96	55.83	56.77	971579.0
2012-01-03 09:00:00	QQQ	ETF	56.77	57.189	56.76	57.03	6213499.0
2012-01-03 10:00:00	QQQ	ETF	57.04	57.19	56.99	57.14	4983890.0
2012-01-03 11:00:00	QQQ	ETF	57.14	57.17	56.98	57.01	2951110.0
2012-01-03 12:00:00	QQQ	ETF	57.01	57.055	56.75	56.84	4148277.0
2012-01-03 13:00:00	QQQ	ETF	56.8498	56.94	56.78	56.92	3611168.0
2012-01-03 14:00:00	QQQ	ETF	56.91	57.1	56.9099	57.1	5394630.0
2012-01-03 15:00:00	QQQ	ETF	57.1	57.11	56.86	56.9	8125569.0
2012-01-03 16:00:00	QQQ	ETF	56.9	57.006	56.84	56.91	1606282.0
2012-01-03 17:00:00	QQQ	ETF	56.91	56.91	56.85	56.9	7500.0
2012-01-03 18:00:00	QQQ	ETF	56.93	56.95	56.92	56.92	7068.0
2012-01-03 19:00:00	QQQ	ETF	56.9	56.92	56.89	56.9	21570.0
2012-01-03 04:00:00	IWM	ETF	75.8	75.8	75.8	75.8	1000.0
2012-01-03 06:00:00	IWM	ETF	75.73	75.75	75.6	75.73	3100.0
2012-01-03 07:00:00	IWM	ETF	75.6	75.75	75.38	75.43	119000.0
2012-01-03 08:00:00	IWM	ETF	75.41	75.78	73.75	75.48	229375.0
2012-01-03 09:00:00	IWM	ETF	73.75	75.87	73.75	75.4799	8172097.0
2012-01-03 10:00:00	IWM	ETF	75.48	75.81	75.42	75.78	8995853.0
2012-01-03 11:00:00	IWM	ETF	75.79	75.8	75.19	75.19	5657372.0
2012-01-03 12:00:00	IWM	ETF	75.19	75.2771	74.78	74.88	5977272.0
2012-01-03 13:00:00	IWM	ETF	74.88	75.14	74.77	75.07	5908713.0
2012-01-03 14:00:00	IWM	ETF	75.08	75.42	74.92	75.41	5899647.0
2012-01-03 15:00:00	IWM	ETF	75.4	75.43	74.93	75.02	9990318.0
2012-01-03 16:00:00	IWM	ETF	75.02	75.745	73.9057	75.04	3561594.0
2012-01-03 17:00:00	IWM	ETF	75.04	75.11	75.04	75.05	42208.0
2012-01-03 18:00:00	IWM	ETF	75.09	75.12	75.08	75.09	27919.0
2012-01-03 19:00:00	IWM	ETF	75.09	75.1	75.06	75.06	1320.0
2012-01-03 04:00:00	DIA	ETF	124.07	124.07	124.07	124.07	100.0
2012-01-03 05:00:00	DIA	ETF	123.95	123.95	123.95	123.95	2927.0
2012-01-03 07:00:00	DIA	ETF	124.0	124.0	123.88	124.0	3290.0
2012-01-03 08:00:00	DIA	ETF	123.56	123.87	123.45	123.87	32505.0

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

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