PREVIEW / etf_1hour / 2008-02-28

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-02-28.parquet
  size:    99 KB
  rows:    3,341

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-28 04:00:00	SPY	ETF	137.68	137.68	137.5	137.53	2100.0
2008-02-28 05:00:00	SPY	ETF	137.51	137.61	137.4	137.52	8100.0
2008-02-28 06:00:00	SPY	ETF	137.58	137.78	137.41	137.75	96400.0
2008-02-28 07:00:00	SPY	ETF	137.8	137.83	137.47	137.47	569000.0
2008-02-28 08:00:00	SPY	ETF	137.51	137.66	137.04	137.11	8337900.0
2008-02-28 09:00:00	SPY	ETF	137.1	137.59	137.05	137.4	21590979.0
2008-02-28 10:00:00	SPY	ETF	137.41	137.96	137.22	137.5	27394653.0
2008-02-28 11:00:00	SPY	ETF	137.49	137.56	136.55	136.95	30299899.0
2008-02-28 12:00:00	SPY	ETF	136.96	137.16	136.65	136.9	9146033.0
2008-02-28 13:00:00	SPY	ETF	136.9	137.3	136.7	137.1	12339389.0
2008-02-28 14:00:00	SPY	ETF	137.09	137.67	136.8	137.64	20585219.0
2008-02-28 15:00:00	SPY	ETF	137.63	137.66	136.83	136.99	26666074.0
2008-02-28 16:00:00	SPY	ETF	136.9601	138.2546	136.55	136.57	9973000.0
2008-02-28 17:00:00	SPY	ETF	136.59	136.82	136.57	136.66	565700.0
2008-02-28 18:00:00	SPY	ETF	136.62	136.66	136.23	136.3	758800.0
2008-02-28 19:00:00	SPY	ETF	136.38	136.38	136.03	136.1	160100.0
2008-02-28 05:00:00	QQQ	ETF	44.17	44.17	44.17	44.17	1000.0
2008-02-28 06:00:00	QQQ	ETF	44.2	44.2	44.18	44.18	18000.0
2008-02-28 07:00:00	QQQ	ETF	44.28	44.28	44.16	44.16	265497.0
2008-02-28 08:00:00	QQQ	ETF	44.16	44.2	44.0	44.07	2294144.0
2008-02-28 09:00:00	QQQ	ETF	44.07	44.35	44.03	44.25	22138763.0
2008-02-28 10:00:00	QQQ	ETF	44.25	44.53	44.18	44.36	25965275.0
2008-02-28 11:00:00	QQQ	ETF	44.35	44.38	43.95	44.09	23868422.0
2008-02-28 12:00:00	QQQ	ETF	44.09	44.22	44.0	44.12	8045289.0
2008-02-28 13:00:00	QQQ	ETF	44.12	44.25	44.06	44.2001	4892760.0
2008-02-28 14:00:00	QQQ	ETF	44.21	44.48	44.1	44.4799	15298650.0
2008-02-28 15:00:00	QQQ	ETF	44.48	44.48	44.11	44.13	19179071.0
2008-02-28 16:00:00	QQQ	ETF	44.13	44.17	43.76	43.87	6733253.0
2008-02-28 17:00:00	QQQ	ETF	43.86	43.98	43.84	43.96	253649.0
2008-02-28 18:00:00	QQQ	ETF	43.96	43.96	43.79	43.83	183000.0
2008-02-28 19:00:00	QQQ	ETF	43.83	43.83	43.75	43.77	59874.0
2008-02-28 06:00:00	IWM	ETF	71.09	71.09	71.09	71.09	2400.0
2008-02-28 07:00:00	IWM	ETF	71.15	71.15	70.83	70.89	78500.0
2008-02-28 08:00:00	IWM	ETF	70.86	70.93	70.68	70.71	277600.0
2008-02-28 09:00:00	IWM	ETF	70.68	71.03	70.48	70.77	7615913.0
2008-02-28 10:00:00	IWM	ETF	70.77	71.14	70.62	70.78	11695074.0
2008-02-28 11:00:00	IWM	ETF	70.78	70.78	69.98	70.24	14661916.0
2008-02-28 12:00:00	IWM	ETF	70.24	70.5	70.09	70.29	7459570.0
2008-02-28 13:00:00	IWM	ETF	70.29	70.62	70.2	70.49	5444033.0
2008-02-28 14:00:00	IWM	ETF	70.49	71.1	70.34	71.08	7158102.0
2008-02-28 15:00:00	IWM	ETF	71.08	71.11	70.32	70.32	9833374.0
2008-02-28 16:00:00	IWM	ETF	70.32	71.42	69.98	69.99	2443300.0
2008-02-28 17:00:00	IWM	ETF	70.0	70.32	70.0	70.12	3020600.0
2008-02-28 18:00:00	IWM	ETF	70.03	70.03	69.97	69.98	6900.0
2008-02-28 19:00:00	IWM	ETF	69.95	69.99	69.84	69.86	29000.0
2008-02-28 07:00:00	DIA	ETF	126.64	126.64	126.47	126.47	22600.0
2008-02-28 08:00:00	DIA	ETF	126.43	126.43	126.01	126.06	206700.0
2008-02-28 09:00:00	DIA	ETF	126.02	126.26	125.78	126.07	1710204.0
2008-02-28 10:00:00	DIA	ETF	126.1	126.47	125.87	126.1	1586236.0
2008-02-28 11:00:00	DIA	ETF	126.1	126.14	125.38	125.71	1589634.0

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

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