PREVIEW / etf_30min / 2007-06-08

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-06-08.parquet
  size:    122 KB
  rows:    4,517

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
2007-06-08 04:00:00	SPY	ETF	149.65	149.67	149.58	149.6	15000.0
2007-06-08 04:30:00	SPY	ETF	149.51	149.6	149.51	149.6	2900.0
2007-06-08 05:00:00	SPY	ETF	149.6	149.63	149.6	149.63	2000.0
2007-06-08 05:30:00	SPY	ETF	149.2	149.2	148.69	148.73	9100.0
2007-06-08 06:00:00	SPY	ETF	148.62	148.68	148.33	148.64	46700.0
2007-06-08 06:30:00	SPY	ETF	148.7	148.91	148.7	148.86	34000.0
2007-06-08 07:00:00	SPY	ETF	148.81	148.9	148.5	148.89	967100.0
2007-06-08 07:30:00	SPY	ETF	148.87	149.3	148.87	149.1	1234600.0
2007-06-08 08:00:00	SPY	ETF	148.72	149.55	148.56	149.32	4881800.0
2007-06-08 08:30:00	SPY	ETF	149.34	149.43	149.08	149.12	2666800.0
2007-06-08 09:00:00	SPY	ETF	149.1	149.54	149.06	149.45	1961200.0
2007-06-08 09:30:00	SPY	ETF	149.42	149.99	149.09	149.85	34646439.0
2007-06-08 10:00:00	SPY	ETF	149.85	150.05	149.35	149.87	16895534.0
2007-06-08 10:30:00	SPY	ETF	149.89	150.0	149.65	149.78	13707068.0
2007-06-08 11:00:00	SPY	ETF	149.78	149.8	149.36	149.72	11517158.0
2007-06-08 11:30:00	SPY	ETF	149.71	150.1	149.63	149.95	6193218.0
2007-06-08 12:00:00	SPY	ETF	149.95	149.97	149.73	149.83	4208900.0
2007-06-08 12:30:00	SPY	ETF	149.84	149.87	149.57	149.86	4801492.0
2007-06-08 13:00:00	SPY	ETF	149.86	149.97	149.69	149.94	2914597.0
2007-06-08 13:30:00	SPY	ETF	149.93	150.41	149.89	150.22	14942428.0
2007-06-08 14:00:00	SPY	ETF	150.22	150.67	150.2	150.46	14043177.0
2007-06-08 14:30:00	SPY	ETF	150.46	150.72	150.33	150.56	9545883.0
2007-06-08 15:00:00	SPY	ETF	150.56	150.91	150.56	150.66	10238811.0
2007-06-08 15:30:00	SPY	ETF	150.66	151.19	150.64	151.05	15154306.0
2007-06-08 16:00:00	SPY	ETF	151.04	151.12	150.9	150.9	2604600.0
2007-06-08 16:30:00	SPY	ETF	150.9	151.05	150.87	151.02	148100.0
2007-06-08 17:00:00	SPY	ETF	151.05	151.15	150.98	151.15	54900.0
2007-06-08 17:30:00	SPY	ETF	151.19	151.21	151.07	151.15	1071300.0
2007-06-08 18:00:00	SPY	ETF	151.16	151.16	151.14	151.15	17000.0
2007-06-08 18:30:00	SPY	ETF	151.15	151.15	151.15	151.15	500.0
2007-06-08 19:00:00	SPY	ETF	151.15	151.15	151.12	151.15	2300.0
2007-06-08 19:30:00	SPY	ETF	151.15	151.15	151.1	151.14	4500.0
2007-06-08 04:30:00	QQQ	ETF	46.45	46.45	46.43	46.43	10000.0
2007-06-08 05:30:00	QQQ	ETF	46.34	46.34	46.34	46.34	100.0
2007-06-08 06:00:00	QQQ	ETF	46.12	46.12	46.09	46.12	8600.0
2007-06-08 06:30:00	QQQ	ETF	46.24	46.24	46.24	46.24	2000.0
2007-06-08 07:00:00	QQQ	ETF	46.2	46.21	46.08	46.18	565986.0
2007-06-08 07:30:00	QQQ	ETF	46.17	46.33	46.17	46.26	861922.0
2007-06-08 08:00:00	QQQ	ETF	46.27	46.43	46.13	46.35	1472060.0
2007-06-08 08:30:00	QQQ	ETF	46.33	46.36	46.23	46.23	1002043.0
2007-06-08 09:00:00	QQQ	ETF	46.24	46.41	46.23	46.32	1954085.0
2007-06-08 09:30:00	QQQ	ETF	46.33	46.54	46.16	46.51	24328124.0
2007-06-08 10:00:00	QQQ	ETF	46.51	46.68	46.4	46.64	22794832.0
2007-06-08 10:30:00	QQQ	ETF	46.65	46.67	46.53	46.56	15375358.0
2007-06-08 11:00:00	QQQ	ETF	46.57	46.57	46.43	46.54	10357285.0
2007-06-08 11:30:00	QQQ	ETF	46.54	46.63	46.5	46.61	4379295.0
2007-06-08 12:00:00	QQQ	ETF	46.61	46.62	46.53	46.59	8423026.0
2007-06-08 12:30:00	QQQ	ETF	46.59	46.61	46.5	46.61	13815956.0
2007-06-08 13:00:00	QQQ	ETF	46.6099	46.67	46.55	46.65	3806976.0
2007-06-08 13:30:00	QQQ	ETF	46.66	46.83	46.63	46.76	14170380.0

> showing 50 of 4,517 rows — these rows as CSV

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