PREVIEW / etf_1hour / 2008-02-29

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-02-29.parquet
  size:    103 KB
  rows:    3,436

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-02-29 04:00:00	SPY	ETF	136.36	136.36	136.3	136.3	7700.0
2008-02-29 05:00:00	SPY	ETF	136.16	136.17	136.0	136.02	5200.0
2008-02-29 06:00:00	SPY	ETF	135.97	135.97	135.33	135.71	511600.0
2008-02-29 07:00:00	SPY	ETF	135.71	135.86	135.2	135.32	1545000.0
2008-02-29 08:00:00	SPY	ETF	135.32	136.87	135.17	135.68	4777200.0
2008-02-29 09:00:00	SPY	ETF	135.68	135.79	134.81	135.15	30148428.0
2008-02-29 10:00:00	SPY	ETF	135.16	135.23	134.25	134.59	34536540.0
2008-02-29 11:00:00	SPY	ETF	134.58	134.94	134.39	134.7	19310750.0
2008-02-29 12:00:00	SPY	ETF	134.7	134.98	134.4	134.63	16353086.0
2008-02-29 13:00:00	SPY	ETF	134.64	134.86	133.86	133.88	31150294.0
2008-02-29 14:00:00	SPY	ETF	133.88	134.01	133.51	133.81	28823727.0
2008-02-29 15:00:00	SPY	ETF	133.81	137.0249	132.78	133.23	52499942.0
2008-02-29 16:00:00	SPY	ETF	133.48	138.22	133.23	133.42	22638900.0
2008-02-29 17:00:00	SPY	ETF	137.0249	137.0249	133.37	133.64	2694200.0
2008-02-29 18:00:00	SPY	ETF	133.58	133.59	133.46	133.46	14400.0
2008-02-29 19:00:00	SPY	ETF	133.46	133.52	133.41	133.41	50700.0
2008-02-29 05:00:00	QQQ	ETF	43.57	43.57	43.57	43.57	6000.0
2008-02-29 06:00:00	QQQ	ETF	43.61	43.61	43.29	43.5	39900.0
2008-02-29 07:00:00	QQQ	ETF	43.56	43.57	43.4	43.43	198741.0
2008-02-29 08:00:00	QQQ	ETF	43.43	43.64	43.39	43.58	2242887.0
2008-02-29 09:00:00	QQQ	ETF	43.6	43.77	43.5	43.67	17589052.0
2008-02-29 10:00:00	QQQ	ETF	43.68	43.68	43.17	43.29	39849561.0
2008-02-29 11:00:00	QQQ	ETF	43.29	43.39	43.21	43.29	12791582.0
2008-02-29 12:00:00	QQQ	ETF	43.299	43.39	43.21	43.35	11332552.0
2008-02-29 13:00:00	QQQ	ETF	43.35	43.48	43.1	43.11	24673922.0
2008-02-29 14:00:00	QQQ	ETF	43.11	43.24	43.0	43.14	22967340.0
2008-02-29 15:00:00	QQQ	ETF	43.14	44.1651	42.85	42.978	47730450.0
2008-02-29 16:00:00	QQQ	ETF	42.96	44.1651	42.855	42.97	11992558.0
2008-02-29 17:00:00	QQQ	ETF	42.95	42.96	42.88	42.94	188507.0
2008-02-29 18:00:00	QQQ	ETF	42.94	42.95	42.9	42.92	85181.0
2008-02-29 19:00:00	QQQ	ETF	42.91	42.94	42.82	42.82	41867.0
2008-02-29 06:00:00	IWM	ETF	69.5	69.5	69.5	69.5	100.0
2008-02-29 07:00:00	IWM	ETF	69.6	69.64	69.39	69.4	112400.0
2008-02-29 08:00:00	IWM	ETF	69.76	69.76	69.38	69.63	476500.0
2008-02-29 09:00:00	IWM	ETF	69.57	69.7	69.07	69.4	10029129.0
2008-02-29 10:00:00	IWM	ETF	69.4	69.54	68.87	69.05	13580045.0
2008-02-29 11:00:00	IWM	ETF	69.05	69.28	68.98	69.21	6406997.0
2008-02-29 12:00:00	IWM	ETF	69.21	69.46	69.07	69.19	6776034.0
2008-02-29 13:00:00	IWM	ETF	69.2	69.4	68.67	68.68	17754818.0
2008-02-29 14:00:00	IWM	ETF	68.68	68.88	68.55	68.73	9677834.0
2008-02-29 15:00:00	IWM	ETF	68.72	68.85	68.1	68.46	23595114.0
2008-02-29 16:00:00	IWM	ETF	68.46	68.94	68.41	68.89	10161101.0
2008-02-29 17:00:00	IWM	ETF	68.77	68.77	68.65	68.73	19000.0
2008-02-29 18:00:00	IWM	ETF	68.83	68.83	68.8	68.8	1200.0
2008-02-29 19:00:00	IWM	ETF	68.8	68.8	68.8	68.8	4700.0
2008-02-29 07:00:00	DIA	ETF	124.9	124.9	124.49	124.49	14300.0
2008-02-29 08:00:00	DIA	ETF	124.56	124.8	124.45	124.78	96600.0
2008-02-29 09:00:00	DIA	ETF	124.77	124.78	123.93	124.24	2250995.0
2008-02-29 10:00:00	DIA	ETF	124.24	124.29	123.4	123.64	4154365.0
2008-02-29 11:00:00	DIA	ETF	123.64	123.95	123.49	123.81	1044041.0

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

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