PREVIEW / etf_1hour / 2008-04-14

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-04-14.parquet
  size:    100 KB
  rows:    3,266

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-04-14 04:00:00	SPY	ETF	133.08	133.18	132.95	133.09	141000.0
2008-04-14 05:00:00	SPY	ETF	133.09	133.27	133.04	133.16	130810.0
2008-04-14 06:00:00	SPY	ETF	133.01	133.1	132.67	132.75	276000.0
2008-04-14 07:00:00	SPY	ETF	132.8	132.85	132.62	132.63	878298.0
2008-04-14 08:00:00	SPY	ETF	132.63	133.37	132.45	133.02	4689457.0
2008-04-14 09:00:00	SPY	ETF	133.0	133.28	132.95	133.2	19412742.0
2008-04-14 10:00:00	SPY	ETF	133.2	133.38	132.74	133.22	30543950.0
2008-04-14 11:00:00	SPY	ETF	133.21	133.3	132.57	132.92	20083126.0
2008-04-14 12:00:00	SPY	ETF	132.91	133.52	132.77	133.49	21996550.0
2008-04-14 13:00:00	SPY	ETF	133.48	133.54	132.91	133.03	14373264.0
2008-04-14 14:00:00	SPY	ETF	133.03	133.17	132.7	132.74	15755348.0
2008-04-14 15:00:00	SPY	ETF	132.74	132.97	132.55	132.81	24058496.0
2008-04-14 16:00:00	SPY	ETF	132.81	133.04	132.77	132.94	3636100.0
2008-04-14 17:00:00	SPY	ETF	132.96	133.02	132.79	132.96	1145418.0
2008-04-14 18:00:00	SPY	ETF	132.92	132.94	132.8	132.85	47970.0
2008-04-14 19:00:00	SPY	ETF	132.82	133.1	132.82	133.1	24280.0
2008-04-14 05:00:00	QQQ	ETF	44.3	44.3	44.28	44.28	300.0
2008-04-14 06:00:00	QQQ	ETF	44.22	44.24	44.06	44.06	3600.0
2008-04-14 07:00:00	QQQ	ETF	44.13	44.13	44.01	44.03	234081.0
2008-04-14 08:00:00	QQQ	ETF	44.03	44.16	43.94	44.12	1118633.0
2008-04-14 09:00:00	QQQ	ETF	44.12	44.26	43.95	44.12	14625719.0
2008-04-14 10:00:00	QQQ	ETF	44.12	44.33	44.03	44.2899	15345070.0
2008-04-14 11:00:00	QQQ	ETF	44.29	44.35	43.99	44.15	10878328.0
2008-04-14 12:00:00	QQQ	ETF	44.15	44.48	44.08	44.4	15513139.0
2008-04-14 13:00:00	QQQ	ETF	44.4	44.44	44.18	44.23	9373538.0
2008-04-14 14:00:00	QQQ	ETF	44.23	44.29	44.07	44.08	8624840.0
2008-04-14 15:00:00	QQQ	ETF	44.0795	44.14	44.0	44.03	10760029.0
2008-04-14 16:00:00	QQQ	ETF	44.03	44.1409	43.99	44.09	2097425.0
2008-04-14 17:00:00	QQQ	ETF	44.08	44.08	44.03	44.03	26722.0
2008-04-14 18:00:00	QQQ	ETF	44.04	44.04	43.99	44.01	21703.0
2008-04-14 19:00:00	QQQ	ETF	44.0	44.07	43.99	44.04	19825.0
2008-04-14 06:00:00	IWM	ETF	68.24	68.24	68.24	68.24	100.0
2008-04-14 07:00:00	IWM	ETF	68.22	68.34	68.2	68.34	5600.0
2008-04-14 08:00:00	IWM	ETF	68.2	68.57	68.16	68.57	354015.0
2008-04-14 09:00:00	IWM	ETF	68.54	68.7	68.23	68.51	5691461.0
2008-04-14 10:00:00	IWM	ETF	68.51	68.75	68.32	68.73	9294825.0
2008-04-14 11:00:00	IWM	ETF	68.74	68.84	68.4	68.64	6307676.0
2008-04-14 12:00:00	IWM	ETF	68.63	69.27	68.6	69.16	11507884.0
2008-04-14 13:00:00	IWM	ETF	69.15	69.17	68.82	68.86	3299446.0
2008-04-14 14:00:00	IWM	ETF	68.87	68.9	68.61	68.63	4382493.0
2008-04-14 15:00:00	IWM	ETF	68.64	68.75	68.36	68.48	7087674.0
2008-04-14 16:00:00	IWM	ETF	68.49	69.75	68.4	68.53	7205761.0
2008-04-14 17:00:00	IWM	ETF	68.57	68.57	68.48	68.53	347583.0
2008-04-14 19:00:00	IWM	ETF	68.45	68.57	68.45	68.56	83022.0
2008-04-14 07:00:00	DIA	ETF	122.95	122.95	122.81	122.81	4000.0
2008-04-14 08:00:00	DIA	ETF	122.8	123.2	122.73	123.16	77246.0
2008-04-14 09:00:00	DIA	ETF	123.15	123.5	123.13	123.48	1581528.0
2008-04-14 10:00:00	DIA	ETF	123.46	123.59	123.04	123.37	2396664.0
2008-04-14 11:00:00	DIA	ETF	123.35	123.45	122.79	123.16	1870607.0
2008-04-14 12:00:00	DIA	ETF	123.15	123.68	123.07	123.62	1200260.0

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

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