PREVIEW / etf_30min / 2007-08-28

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-08-28.parquet
  size:    126 KB
  rows:    4,639

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-08-28 04:00:00	SPY	ETF	146.43	146.43	146.41	146.41	2000.0
2007-08-28 06:00:00	SPY	ETF	146.61	146.61	146.61	146.61	10000.0
2007-08-28 06:30:00	SPY	ETF	146.41	146.46	146.41	146.42	20500.0
2007-08-28 07:00:00	SPY	ETF	146.4	146.45	146.21	146.31	544400.0
2007-08-28 07:30:00	SPY	ETF	146.34	146.43	146.32	146.38	75600.0
2007-08-28 08:00:00	SPY	ETF	146.39	146.4	146.21	146.28	844600.0
2007-08-28 08:30:00	SPY	ETF	146.26	146.39	146.21	146.26	562200.0
2007-08-28 09:00:00	SPY	ETF	146.22	146.39	146.06	146.16	2415000.0
2007-08-28 09:30:00	SPY	ETF	146.16	146.25	145.65	145.79	24122728.0
2007-08-28 10:00:00	SPY	ETF	145.79	145.98	145.51	145.73	18124900.0
2007-08-28 10:30:00	SPY	ETF	145.73	145.82	145.29	145.45	14138100.0
2007-08-28 11:00:00	SPY	ETF	145.45	145.6	145.11	145.26	12927400.0
2007-08-28 11:30:00	SPY	ETF	145.27	145.36	144.82	145.02	13043600.0
2007-08-28 12:00:00	SPY	ETF	145.03	145.23	144.99	145.14	6533500.0
2007-08-28 12:30:00	SPY	ETF	145.149	145.36	145.14	145.25	8137100.0
2007-08-28 13:00:00	SPY	ETF	145.25	145.27	145.02	145.16	4581900.0
2007-08-28 13:30:00	SPY	ETF	145.17	145.35	145.08	145.33	4184500.0
2007-08-28 14:00:00	SPY	ETF	145.33	145.4	144.81	145.06	18961900.0
2007-08-28 14:30:00	SPY	ETF	145.06	145.12	144.44	144.59	20275200.0
2007-08-28 15:00:00	SPY	ETF	144.59	144.69	144.17	144.23	17301700.0
2007-08-28 15:30:00	SPY	ETF	144.23	144.24	143.46	143.66	32748800.0
2007-08-28 16:00:00	SPY	ETF	143.73	145.1	143.65	143.75	4395100.0
2007-08-28 16:30:00	SPY	ETF	143.77	143.94	143.71	143.71	3915300.0
2007-08-28 17:00:00	SPY	ETF	143.71	143.73	143.6	143.65	271200.0
2007-08-28 17:30:00	SPY	ETF	143.62	143.7	143.6	143.67	7700.0
2007-08-28 18:00:00	SPY	ETF	143.69	143.87	143.67	143.78	43800.0
2007-08-28 18:30:00	SPY	ETF	143.78	143.8	143.55	143.73	76300.0
2007-08-28 19:00:00	SPY	ETF	143.77	143.78	143.68	143.68	12800.0
2007-08-28 19:30:00	SPY	ETF	143.68	143.74	143.56	143.56	84700.0
2007-08-28 07:00:00	QQQ	ETF	47.65	47.67	47.58	47.67	277488.0
2007-08-28 07:30:00	QQQ	ETF	47.66	47.68	47.64	47.66	321698.0
2007-08-28 08:00:00	QQQ	ETF	47.66	47.67	47.61	47.63	493770.0
2007-08-28 08:30:00	QQQ	ETF	47.63	47.68	47.62	47.62	398658.0
2007-08-28 09:00:00	QQQ	ETF	47.62	47.63	47.57	47.6	466121.0
2007-08-28 09:30:00	QQQ	ETF	47.5922	47.7	47.49	47.5285	8024515.0
2007-08-28 10:00:00	QQQ	ETF	47.524	47.61	47.46	47.54	8273580.0
2007-08-28 10:30:00	QQQ	ETF	47.54	47.58	47.31	47.39	8274936.0
2007-08-28 11:00:00	QQQ	ETF	47.39	47.39	47.25	47.2985	6930415.0
2007-08-28 11:30:00	QQQ	ETF	47.2985	47.34	47.16	47.25	5660067.0
2007-08-28 12:00:00	QQQ	ETF	47.2599	47.31	47.23	47.27	4112089.0
2007-08-28 12:30:00	QQQ	ETF	47.27	47.31	47.24	47.2889	2626541.0
2007-08-28 13:00:00	QQQ	ETF	47.29	47.3	47.19	47.25	2768098.0
2007-08-28 13:30:00	QQQ	ETF	47.25	47.34	47.22	47.32	3453788.0
2007-08-28 14:00:00	QQQ	ETF	47.31	47.35	47.17	47.27	5769370.0
2007-08-28 14:30:00	QQQ	ETF	47.28	47.31	47.07	47.11	6141468.0
2007-08-28 15:00:00	QQQ	ETF	47.11	47.15	47.0	47.02	7653809.0
2007-08-28 15:30:00	QQQ	ETF	47.02	47.02	46.71	46.74	13480793.0
2007-08-28 16:00:00	QQQ	ETF	46.73	47.2799	46.72	46.84	4427372.0
2007-08-28 16:30:00	QQQ	ETF	46.85	47.3501	46.8	46.8	1870081.0
2007-08-28 17:00:00	QQQ	ETF	46.82	46.85	46.79	46.82	97578.0

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

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