PREVIEW / etf_1hour / 2008-06-09

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-06-09.parquet
  size:    107 KB
  rows:    3,409

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-06-09 04:00:00	SPY	ETF	136.81	137.0	136.81	137.0	60600.0
2008-06-09 05:00:00	SPY	ETF	137.0	137.0	136.71	136.89	115400.0
2008-06-09 06:00:00	SPY	ETF	136.85	136.99	136.58	136.82	272200.0
2008-06-09 07:00:00	SPY	ETF	136.84	136.97	136.28	136.6	1388518.0
2008-06-09 08:00:00	SPY	ETF	136.62	137.03	136.4	136.89	1670622.0
2008-06-09 09:00:00	SPY	ETF	136.92	137.11	136.38	136.99	26633931.0
2008-06-09 10:00:00	SPY	ETF	136.99	137.5	136.8	136.87	42463334.0
2008-06-09 11:00:00	SPY	ETF	136.87	137.41	136.79	137.03	16685055.0
2008-06-09 12:00:00	SPY	ETF	137.03	137.22	136.79	137.15	12487470.0
2008-06-09 13:00:00	SPY	ETF	137.14	137.15	135.82	136.02	31243479.0
2008-06-09 14:00:00	SPY	ETF	136.01	136.38	135.41	135.87	49663716.0
2008-06-09 15:00:00	SPY	ETF	135.87	136.75	135.555	136.63	39060309.0
2008-06-09 16:00:00	SPY	ETF	136.65	136.7624	135.0	136.67	3518184.0
2008-06-09 17:00:00	SPY	ETF	136.66	136.71	136.56	136.68	159228.0
2008-06-09 18:00:00	SPY	ETF	136.66	136.69	136.51	136.51	40915.0
2008-06-09 19:00:00	SPY	ETF	136.53	136.63	136.53	136.63	4399.0
2008-06-09 04:00:00	QQQ	ETF	49.15	49.15	49.15	49.15	800.0
2008-06-09 06:00:00	QQQ	ETF	49.08	49.08	49.03	49.08	300.0
2008-06-09 07:00:00	QQQ	ETF	49.13	49.17	48.92	49.04	333000.0
2008-06-09 08:00:00	QQQ	ETF	49.04	49.2	49.03	49.11	1134437.0
2008-06-09 09:00:00	QQQ	ETF	49.12	49.2	48.41	48.71	22068796.0
2008-06-09 10:00:00	QQQ	ETF	48.72	49.01	48.46	48.4899	36681780.0
2008-06-09 11:00:00	QQQ	ETF	48.49	48.75	48.48	48.65	16136206.0
2008-06-09 12:00:00	QQQ	ETF	48.64	48.74	48.49	48.71	9362678.0
2008-06-09 13:00:00	QQQ	ETF	48.71	48.72	48.0	48.1401	29243101.0
2008-06-09 14:00:00	QQQ	ETF	48.14	48.55	47.95	48.18	40572912.0
2008-06-09 15:00:00	QQQ	ETF	48.18	48.82	48.01	48.77	39545604.0
2008-06-09 16:00:00	QQQ	ETF	48.77	48.89	48.3964	48.84	9590517.0
2008-06-09 17:00:00	QQQ	ETF	48.85	48.88	48.83	48.84	81450.0
2008-06-09 18:00:00	QQQ	ETF	48.84	48.84	48.8	48.82	10775.0
2008-06-09 19:00:00	QQQ	ETF	48.8	48.84	48.8	48.84	21717.0
2008-06-09 06:00:00	IWM	ETF	74.02	74.02	74.02	74.02	200.0
2008-06-09 07:00:00	IWM	ETF	73.92	74.12	73.92	74.0	266024.0
2008-06-09 08:00:00	IWM	ETF	74.02	74.29	74.0	74.14	233496.0
2008-06-09 09:00:00	IWM	ETF	74.18	74.3	73.29	73.94	11980288.0
2008-06-09 10:00:00	IWM	ETF	73.95	74.39	73.65	73.77	20502314.0
2008-06-09 11:00:00	IWM	ETF	73.78	74.01	73.63	73.8	8023312.0
2008-06-09 12:00:00	IWM	ETF	73.81	73.98	73.66	73.96	4273657.0
2008-06-09 13:00:00	IWM	ETF	73.96	73.97	73.13	73.24	10852063.0
2008-06-09 14:00:00	IWM	ETF	73.24	73.41	72.78	73.07	19261736.0
2008-06-09 15:00:00	IWM	ETF	73.09	73.68	72.91	73.67	18587813.0
2008-06-09 16:00:00	IWM	ETF	73.67	73.76	73.37	73.73	3136443.0
2008-06-09 17:00:00	IWM	ETF	73.72	73.9	73.71	73.9	52568.0
2008-06-09 18:00:00	IWM	ETF	73.67	73.67	73.67	73.67	147.0
2008-06-09 19:00:00	IWM	ETF	73.61	73.64	73.61	73.64	900.0
2008-06-09 07:00:00	DIA	ETF	122.61	122.61	122.25	122.4	3069.0
2008-06-09 08:00:00	DIA	ETF	122.38	122.78	122.37	122.78	46280.0
2008-06-09 09:00:00	DIA	ETF	122.78	123.05	122.3	122.98	3127422.0
2008-06-09 10:00:00	DIA	ETF	123.05	123.44	122.87	122.94	3136724.0
2008-06-09 11:00:00	DIA	ETF	122.93	123.36	122.9	123.08	816915.0

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

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