PREVIEW / etf_30min / 2008-05-28

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-05-28.parquet
  size:    163 KB
  rows:    5,633

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-05-28 04:30:00	SPY	ETF	138.89	138.89	138.8	138.8	1500.0
2008-05-28 05:00:00	SPY	ETF	138.84	138.84	138.81	138.81	2070.0
2008-05-28 05:30:00	SPY	ETF	138.92	138.92	138.92	138.92	100.0
2008-05-28 06:00:00	SPY	ETF	138.95	139.13	138.95	139.13	2800.0
2008-05-28 06:30:00	SPY	ETF	139.08	139.08	138.87	138.95	4500.0
2008-05-28 07:00:00	SPY	ETF	138.92	139.08	138.92	139.03	764224.0
2008-05-28 07:30:00	SPY	ETF	139.02	139.28	139.01	139.26	1330214.0
2008-05-28 08:00:00	SPY	ETF	139.24	139.29	138.66	139.04	4788550.0
2008-05-28 08:30:00	SPY	ETF	139.05	139.59	139.05	139.32	4827303.0
2008-05-28 09:00:00	SPY	ETF	139.32	139.34	139.14	139.18	2060888.0
2008-05-28 09:30:00	SPY	ETF	139.17	140.0	138.72	138.9	18760918.0
2008-05-28 10:00:00	SPY	ETF	138.9099	138.92	138.29	138.42	23372004.0
2008-05-28 10:30:00	SPY	ETF	138.42	138.9	138.4	138.8	10347103.0
2008-05-28 11:00:00	SPY	ETF	138.8	138.83	138.37	138.45	7604340.0
2008-05-28 11:30:00	SPY	ETF	138.44	138.67	138.0	138.39	10113854.0
2008-05-28 12:00:00	SPY	ETF	138.4	139.28	138.05	138.53	15486438.0
2008-05-28 12:30:00	SPY	ETF	138.53	138.635	138.4	138.55	5876329.0
2008-05-28 13:00:00	SPY	ETF	138.55	138.85	138.52	138.81	9063978.0
2008-05-28 13:30:00	SPY	ETF	138.81	138.9	138.32	138.52	11547790.0
2008-05-28 14:00:00	SPY	ETF	138.5199	138.63	138.23	138.4478	9783973.0
2008-05-28 14:30:00	SPY	ETF	138.44	138.76	138.39	138.6	6090843.0
2008-05-28 15:00:00	SPY	ETF	138.6	139.22	138.58	139.1	14609182.0
2008-05-28 15:30:00	SPY	ETF	139.1	139.37	138.9	139.37	19338225.0
2008-05-28 16:00:00	SPY	ETF	139.38	139.55	138.3	139.3	1515372.0
2008-05-28 16:30:00	SPY	ETF	139.28	139.3	138.7911	139.23	1405910.0
2008-05-28 17:00:00	SPY	ETF	139.24	139.26	139.08	139.18	31057.0
2008-05-28 17:30:00	SPY	ETF	139.18	139.23	139.18	139.23	4800.0
2008-05-28 18:00:00	SPY	ETF	139.18	139.19	139.18	139.18	5600.0
2008-05-28 18:30:00	SPY	ETF	139.18	139.19	139.16	139.16	8474.0
2008-05-28 19:00:00	SPY	ETF	139.2	139.21	139.16	139.16	5800.0
2008-05-28 19:30:00	SPY	ETF	139.15	139.18	139.13	139.13	2700.0
2008-05-28 04:00:00	QQQ	ETF	49.01	49.01	48.98	48.98	26200.0
2008-05-28 06:30:00	QQQ	ETF	49.08	49.1	49.08	49.1	2600.0
2008-05-28 07:00:00	QQQ	ETF	49.09	49.14	49.09	49.13	545557.0
2008-05-28 07:30:00	QQQ	ETF	49.17	49.24	49.16	49.23	715869.0
2008-05-28 08:00:00	QQQ	ETF	49.22	49.22	49.1295	49.17	1647755.0
2008-05-28 08:30:00	QQQ	ETF	49.18	49.37	49.18	49.34	1912295.0
2008-05-28 09:00:00	QQQ	ETF	49.35	49.36	49.27	49.29	1168909.0
2008-05-28 09:30:00	QQQ	ETF	49.28	49.36	49.06	49.15	15936818.0
2008-05-28 10:00:00	QQQ	ETF	49.1499	49.15	48.86	48.94	13303374.0
2008-05-28 10:30:00	QQQ	ETF	48.94	49.1399	48.93	49.1	8258437.0
2008-05-28 11:00:00	QQQ	ETF	49.09	49.11	48.88	48.91	7012084.0
2008-05-28 11:30:00	QQQ	ETF	48.9107	49.03	48.87	48.9399	5843149.0
2008-05-28 12:00:00	QQQ	ETF	48.94	48.94	48.75	48.89	8330009.0
2008-05-28 12:30:00	QQQ	ETF	48.9	48.93	48.85	48.89	2766914.0
2008-05-28 13:00:00	QQQ	ETF	48.9	49.06	48.87	49.0482	4649335.0
2008-05-28 13:30:00	QQQ	ETF	49.05	49.08	48.89	48.94	9556526.0
2008-05-28 14:00:00	QQQ	ETF	48.95	49.02	48.84	48.9	5993083.0
2008-05-28 14:30:00	QQQ	ETF	48.9099	49.05	48.87	48.97	5968021.0
2008-05-28 15:00:00	QQQ	ETF	48.97	49.16	48.95	49.11	8729014.0

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

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