PREVIEW / etf_1hour / 2008-12-19

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-12-19.parquet
  size:    120 KB
  rows:    3,914

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-12-19 04:00:00	SPY	ETF	88.89	88.92	88.77	88.77	2905.0
2008-12-19 05:00:00	SPY	ETF	88.71	89.0	88.35	88.81	6985.0
2008-12-19 06:00:00	SPY	ETF	88.74	88.76	88.33	88.7	49290.0
2008-12-19 07:00:00	SPY	ETF	88.7	88.8	88.38	88.77	1103965.0
2008-12-19 08:00:00	SPY	ETF	88.75	89.75	88.2	89.68	5792495.0
2008-12-19 09:00:00	SPY	ETF	89.68	89.9	88.73	89.0899	35300502.0
2008-12-19 10:00:00	SPY	ETF	89.08	90.62	89.04	89.9	42420490.0
2008-12-19 11:00:00	SPY	ETF	89.9	89.98	88.75	88.83	43094077.0
2008-12-19 12:00:00	SPY	ETF	88.84	89.07	88.39	88.845	35859142.0
2008-12-19 13:00:00	SPY	ETF	88.84	89.92	88.81	88.98	21954878.0
2008-12-19 14:00:00	SPY	ETF	88.98	89.3391	88.6	88.78	32170065.0
2008-12-19 15:00:00	SPY	ETF	88.79	89.1181	88.09	88.39	56876920.0
2008-12-19 16:00:00	SPY	ETF	88.32	89.8694	87.8	88.2	20205822.0
2008-12-19 17:00:00	SPY	ETF	88.19	88.2	88.06	88.15	132036.0
2008-12-19 18:00:00	SPY	ETF	88.15	88.21	88.15	88.19	48678.0
2008-12-19 19:00:00	SPY	ETF	88.22	88.24	88.18	88.19	18691.0
2008-12-19 04:00:00	QQQ	ETF	29.83	29.83	29.83	29.83	200.0
2008-12-19 05:00:00	QQQ	ETF	29.73	29.73	29.73	29.73	100.0
2008-12-19 06:00:00	QQQ	ETF	29.83	29.83	29.75	29.75	5300.0
2008-12-19 07:00:00	QQQ	ETF	29.76	29.84	29.72	29.8	98571.0
2008-12-19 08:00:00	QQQ	ETF	29.68	30.04	29.68	30.0	1903611.0
2008-12-19 09:00:00	QQQ	ETF	30.02	30.21	29.88	30.05	18991797.0
2008-12-19 10:00:00	QQQ	ETF	30.06	30.37	30.05	30.25	19028205.0
2008-12-19 11:00:00	QQQ	ETF	30.25	30.28	29.91	29.93	12306097.0
2008-12-19 12:00:00	QQQ	ETF	29.9305	29.9826	29.77	29.9	12121135.0
2008-12-19 13:00:00	QQQ	ETF	29.9	30.09	29.88	29.99	8334962.0
2008-12-19 14:00:00	QQQ	ETF	29.99	30.1	29.88	29.95	10328745.0
2008-12-19 15:00:00	QQQ	ETF	29.95	29.98	29.76	29.88	22494046.0
2008-12-19 16:00:00	QQQ	ETF	29.88	29.88	29.68	29.73	4482779.0
2008-12-19 17:00:00	QQQ	ETF	29.74	29.75	29.68	29.72	165423.0
2008-12-19 18:00:00	QQQ	ETF	29.75	29.76	29.73	29.76	21065.0
2008-12-19 19:00:00	QQQ	ETF	29.76	29.76	29.73	29.76	3510.0
2008-12-19 04:00:00	IWM	ETF	48.65	48.65	48.65	48.65	300.0
2008-12-19 05:00:00	IWM	ETF	48.58	48.58	48.44	48.44	12700.0
2008-12-19 07:00:00	IWM	ETF	48.49	48.58	48.38	48.56	27283.0
2008-12-19 08:00:00	IWM	ETF	48.58	48.98	48.5	48.87	824862.0
2008-12-19 09:00:00	IWM	ETF	48.92	49.54	48.78	49.23	9992262.0
2008-12-19 10:00:00	IWM	ETF	49.22	50.01	49.21	49.6	22006519.0
2008-12-19 11:00:00	IWM	ETF	49.61	49.66	48.75	48.82	13136201.0
2008-12-19 12:00:00	IWM	ETF	48.83	49.16	48.56	49.05	7044276.0
2008-12-19 13:00:00	IWM	ETF	49.05	49.56	49.01	49.29	5357631.0
2008-12-19 14:00:00	IWM	ETF	49.3	49.51	48.95	49.1	5318305.0
2008-12-19 15:00:00	IWM	ETF	49.11	49.12	48.21	48.73	17819436.0
2008-12-19 16:00:00	IWM	ETF	48.73	50.0	48.54	48.63	3993529.0
2008-12-19 17:00:00	IWM	ETF	48.65	48.72	48.65	48.65	8824.0
2008-12-19 18:00:00	IWM	ETF	48.8	48.88	48.8	48.88	1300.0
2008-12-19 06:00:00	DIA	ETF	86.45	86.53	86.36	86.36	546.0
2008-12-19 07:00:00	DIA	ETF	86.21	86.41	86.21	86.41	13649.0
2008-12-19 08:00:00	DIA	ETF	86.35	87.37	86.33	87.33	100946.0
2008-12-19 09:00:00	DIA	ETF	87.36	87.49	86.43	86.66	2383313.0

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

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