PREVIEW / etf_30min / 2008-02-15

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-02-15.parquet
  size:    148 KB
  rows:    5,456

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-15 04:00:00	SPY	ETF	135.51	135.56	135.51	135.56	12800.0
2008-02-15 05:00:00	SPY	ETF	135.34	135.34	135.24	135.3	10900.0
2008-02-15 05:30:00	SPY	ETF	135.22	135.22	135.22	135.22	3100.0
2008-02-15 06:30:00	SPY	ETF	135.26	135.26	134.99	134.99	15100.0
2008-02-15 07:00:00	SPY	ETF	135.06	135.07	134.54	134.73	558400.0
2008-02-15 07:30:00	SPY	ETF	134.72	134.77	134.18	134.27	886200.0
2008-02-15 08:00:00	SPY	ETF	134.29	134.48	134.2	134.39	734300.0
2008-02-15 08:30:00	SPY	ETF	134.39	134.57	133.77	134.24	4116400.0
2008-02-15 09:00:00	SPY	ETF	134.22	135.64	134.17	134.55	2275300.0
2008-02-15 09:30:00	SPY	ETF	134.55	134.8542	133.36	134.13	23561011.0
2008-02-15 10:00:00	SPY	ETF	134.13	134.89	134.06	134.67	15122116.0
2008-02-15 10:30:00	SPY	ETF	134.67	135.0	134.4	134.48	11652328.0
2008-02-15 11:00:00	SPY	ETF	134.48	134.66	134.23	134.41	9443365.0
2008-02-15 11:30:00	SPY	ETF	134.4	134.45	134.03	134.2	8568459.0
2008-02-15 12:00:00	SPY	ETF	134.2	134.58	134.0	134.05	7688800.0
2008-02-15 12:30:00	SPY	ETF	134.05	134.24	133.91	134.14	6075350.0
2008-02-15 13:00:00	SPY	ETF	134.14	134.32	133.92	134.16	4981183.0
2008-02-15 13:30:00	SPY	ETF	134.16	134.64	134.0	134.56	5344833.0
2008-02-15 14:00:00	SPY	ETF	134.56	134.6	134.18	134.39	5696144.0
2008-02-15 14:30:00	SPY	ETF	134.38	134.55	134.25	134.44	5969050.0
2008-02-15 15:00:00	SPY	ETF	134.43	134.87	134.35	134.61	10406347.0
2008-02-15 15:30:00	SPY	ETF	134.61	136.1	134.57	135.06	17808231.0
2008-02-15 16:00:00	SPY	ETF	135.06	135.22	135.0	135.18	5190000.0
2008-02-15 16:30:00	SPY	ETF	135.15	135.2	135.0	135.13	4269800.0
2008-02-15 17:00:00	SPY	ETF	135.06	135.19	135.0	135.13	399600.0
2008-02-15 17:30:00	SPY	ETF	135.13	135.25	135.13	135.18	17800.0
2008-02-15 18:00:00	SPY	ETF	135.18	135.3	135.1	135.1	169200.0
2008-02-15 18:30:00	SPY	ETF	135.22	135.22	135.22	135.22	200.0
2008-02-15 19:00:00	SPY	ETF	135.21	135.22	135.21	135.22	400.0
2008-02-15 19:30:00	SPY	ETF	135.22	135.22	135.15	135.15	1400.0
2008-02-15 04:00:00	QQQ	ETF	44.08	44.17	44.08	44.17	2200.0
2008-02-15 06:00:00	QQQ	ETF	43.98	43.98	43.98	43.98	4700.0
2008-02-15 06:30:00	QQQ	ETF	44.01	44.01	43.97	43.97	5700.0
2008-02-15 07:00:00	QQQ	ETF	43.93	43.93	43.8	43.82	148566.0
2008-02-15 07:30:00	QQQ	ETF	43.85	43.88	43.72	43.73	131757.0
2008-02-15 08:00:00	QQQ	ETF	43.73	43.75	43.66	43.72	442112.0
2008-02-15 08:30:00	QQQ	ETF	43.7	43.72	43.51	43.7	1214627.0
2008-02-15 09:00:00	QQQ	ETF	43.71	43.86	43.71	43.79	1494744.0
2008-02-15 09:30:00	QQQ	ETF	43.78	43.92	43.62	43.7	18030749.0
2008-02-15 10:00:00	QQQ	ETF	43.69	43.84	43.67	43.8	8988893.0
2008-02-15 10:30:00	QQQ	ETF	43.79	43.98	43.74	43.75	7562007.0
2008-02-15 11:00:00	QQQ	ETF	43.75	43.8	43.65	43.712	4499000.0
2008-02-15 11:30:00	QQQ	ETF	43.71	43.72	43.56	43.66	4816363.0
2008-02-15 12:00:00	QQQ	ETF	43.65	43.76	43.57	43.58	5024206.0
2008-02-15 12:30:00	QQQ	ETF	43.57	43.59	43.5	43.56	6677530.0
2008-02-15 13:00:00	QQQ	ETF	43.56	43.6	43.45	43.5001	4638848.0
2008-02-15 13:30:00	QQQ	ETF	43.51	43.68	43.49	43.65	3286316.0
2008-02-15 14:00:00	QQQ	ETF	43.6425	43.66	43.5	43.57	4338484.0
2008-02-15 14:30:00	QQQ	ETF	43.56	43.61	43.5	43.58	3057807.0
2008-02-15 15:00:00	QQQ	ETF	43.57	43.72	43.52	43.65	6779872.0

> showing 50 of 5,456 rows — these rows as CSV

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