PREVIEW / etf_1hour / 2009-12-01

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-12-01.parquet
  size:    149 KB
  rows:    4,638

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-12-01 04:00:00	SPY	ETF	110.72	110.99	110.7	110.79	10200.0
2009-12-01 05:00:00	SPY	ETF	110.8	110.89	110.68	110.68	1100.0
2009-12-01 06:00:00	SPY	ETF	110.68	110.9	110.65	110.9	29200.0
2009-12-01 07:00:00	SPY	ETF	110.9	110.97	110.77	110.8	851658.0
2009-12-01 08:00:00	SPY	ETF	110.8	110.93	110.74	110.87	1398484.0
2009-12-01 09:00:00	SPY	ETF	110.87	111.33	109.94	111.13	23419842.0
2009-12-01 10:00:00	SPY	ETF	111.13	111.29	110.73	111.028	32177971.0
2009-12-01 11:00:00	SPY	ETF	111.025	111.36	111.01	111.2805	17326102.0
2009-12-01 12:00:00	SPY	ETF	111.29	111.43	111.21	111.31	11993251.0
2009-12-01 13:00:00	SPY	ETF	111.31	111.66	111.27	111.53	12468142.0
2009-12-01 14:00:00	SPY	ETF	111.53	111.63	111.3	111.39	14894446.0
2009-12-01 15:00:00	SPY	ETF	111.39	111.48	111.13	111.25	30071193.0
2009-12-01 16:00:00	SPY	ETF	111.24	111.51	109.9747	111.29	10270486.0
2009-12-01 17:00:00	SPY	ETF	111.55	111.55	111.24	111.28	146511.0
2009-12-01 18:00:00	SPY	ETF	111.28	111.37	111.26	111.34	44882.0
2009-12-01 19:00:00	SPY	ETF	111.28	111.37	111.21	111.35	36313.0
2009-12-01 04:00:00	QQQ	ETF	43.87	43.92	43.87	43.92	15950.0
2009-12-01 05:00:00	QQQ	ETF	43.92	43.92	43.92	43.92	600.0
2009-12-01 06:00:00	QQQ	ETF	43.91	43.93	43.91	43.93	8700.0
2009-12-01 07:00:00	QQQ	ETF	43.95	43.96	43.88	43.9	71600.0
2009-12-01 08:00:00	QQQ	ETF	43.9	43.93	43.84	43.91	397119.0
2009-12-01 09:00:00	QQQ	ETF	43.92	44.14	43.56	44.1	11529029.0
2009-12-01 10:00:00	QQQ	ETF	44.09	44.16	43.93	44.07	13637640.0
2009-12-01 11:00:00	QQQ	ETF	44.08	44.18	44.04	44.1505	10708241.0
2009-12-01 12:00:00	QQQ	ETF	44.16	44.24	44.15	44.208	5279449.0
2009-12-01 13:00:00	QQQ	ETF	44.208	44.3	44.18	44.23	4648072.0
2009-12-01 14:00:00	QQQ	ETF	44.24	44.29	44.15	44.18	6126521.0
2009-12-01 15:00:00	QQQ	ETF	44.18	44.22	43.98	44.01	17098625.0
2009-12-01 16:00:00	QQQ	ETF	44.02	44.18	43.5301	44.09	6044246.0
2009-12-01 17:00:00	QQQ	ETF	44.09	44.11	44.07	44.08	9736.0
2009-12-01 18:00:00	QQQ	ETF	44.09	44.13	44.09	44.11	17986.0
2009-12-01 19:00:00	QQQ	ETF	44.09	44.12	44.07	44.11	40187.0
2009-12-01 06:00:00	IWM	ETF	59.01	59.09	58.99	59.04	86701.0
2009-12-01 07:00:00	IWM	ETF	59.02	59.02	58.64	58.71	22413.0
2009-12-01 08:00:00	IWM	ETF	58.65	58.79	58.1	58.74	435612.0
2009-12-01 09:00:00	IWM	ETF	58.73	59.1	58.09	58.81	10747800.0
2009-12-01 10:00:00	IWM	ETF	58.81	58.96	58.46	58.68	11287011.0
2009-12-01 11:00:00	IWM	ETF	58.68	58.95	58.59	58.92	7171444.0
2009-12-01 12:00:00	IWM	ETF	58.91	59.03	58.84	58.92	3724245.0
2009-12-01 13:00:00	IWM	ETF	58.9299	59.2178	58.6	59.19	4166432.0
2009-12-01 14:00:00	IWM	ETF	59.19	59.23	58.82	58.9	6941031.0
2009-12-01 15:00:00	IWM	ETF	58.9	59.12	58.82	59.04	9998626.0
2009-12-01 16:00:00	IWM	ETF	59.03	59.13	58.0911	59.05	3258727.0
2009-12-01 17:00:00	IWM	ETF	59.03	59.06	59.01	59.02	17640.0
2009-12-01 18:00:00	IWM	ETF	59.02	59.11	59.02	59.11	629.0
2009-12-01 19:00:00	IWM	ETF	59.02	59.06	59.02	59.03	3200.0
2009-12-01 04:00:00	DIA	ETF	104.0	104.0	104.0	104.0	100.0
2009-12-01 07:00:00	DIA	ETF	104.25	104.3	104.25	104.3	3200.0
2009-12-01 08:00:00	DIA	ETF	104.33	104.33	104.15	104.25	10850.0
2009-12-01 09:00:00	DIA	ETF	104.24	104.78	104.2	104.65	1784358.0

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

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