PREVIEW / etf_30min / 2007-03-13

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-03-13.parquet
  size:    111 KB
  rows:    3,721

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-03-13 04:00:00	SPY	ETF	140.82	140.82	140.82	140.82	100.0
2007-03-13 06:00:00	SPY	ETF	140.87	140.87	140.87	140.87	200.0
2007-03-13 06:30:00	SPY	ETF	140.8	140.8	140.74	140.74	21000.0
2007-03-13 07:00:00	SPY	ETF	140.72	140.72	140.36	140.52	185200.0
2007-03-13 07:30:00	SPY	ETF	140.5	140.52	140.21	140.4	679400.0
2007-03-13 08:00:00	SPY	ETF	140.89	140.89	140.27	140.5	3274600.0
2007-03-13 08:30:00	SPY	ETF	140.45	140.46	140.16	140.25	2374800.0
2007-03-13 09:00:00	SPY	ETF	140.21	140.26	139.99	140.24	2015400.0
2007-03-13 09:30:00	SPY	ETF	140.24	140.58	140.02	140.44	10836000.0
2007-03-13 10:00:00	SPY	ETF	140.43	140.63	140.2	140.6	9933200.0
2007-03-13 10:30:00	SPY	ETF	140.61	140.74	140.45	140.62	6461100.0
2007-03-13 11:00:00	SPY	ETF	140.62	140.77	140.45	140.46	5829100.0
2007-03-13 11:30:00	SPY	ETF	140.45	140.57	140.32	140.38	5242400.0
2007-03-13 12:00:00	SPY	ETF	140.38	140.48	139.63	139.64	18270100.0
2007-03-13 12:30:00	SPY	ETF	139.64	139.82	139.36	139.55	12822600.0
2007-03-13 13:00:00	SPY	ETF	139.55	139.71	139.43	139.46	6731300.0
2007-03-13 13:30:00	SPY	ETF	139.47	139.48	138.9	139.27	13957100.0
2007-03-13 14:00:00	SPY	ETF	139.26	139.34	138.39	138.75	14143400.0
2007-03-13 14:30:00	SPY	ETF	138.75	138.98	138.54	138.63	10139100.0
2007-03-13 15:00:00	SPY	ETF	138.62	139.0	138.24	138.73	14811300.0
2007-03-13 15:30:00	SPY	ETF	138.73	139.0	138.11	138.15	24170600.0
2007-03-13 16:00:00	SPY	ETF	138.16	140.4	138.04	138.24	3840600.0
2007-03-13 16:30:00	SPY	ETF	138.24	138.33	138.24	138.33	2218900.0
2007-03-13 17:00:00	SPY	ETF	138.3	138.37	138.27	138.3	1216300.0
2007-03-13 17:30:00	SPY	ETF	138.33	138.4	138.24	138.3	60900.0
2007-03-13 18:00:00	SPY	ETF	138.3	138.38	138.23	138.24	4687500.0
2007-03-13 18:30:00	SPY	ETF	138.28	138.28	138.22	138.22	509800.0
2007-03-13 19:00:00	SPY	ETF	138.25	138.27	138.22	138.23	508000.0
2007-03-13 19:30:00	SPY	ETF	138.23	138.24	138.11	138.14	13000.0
2007-03-13 06:00:00	QQQ	ETF	43.17	43.17	43.17	43.17	100.0
2007-03-13 07:00:00	QQQ	ETF	43.12	43.12	42.98	43.0	208800.0
2007-03-13 07:30:00	QQQ	ETF	43.02	43.02	42.96	43.0	669779.0
2007-03-13 08:00:00	QQQ	ETF	43.02	43.08	42.99	43.05	1941822.0
2007-03-13 08:30:00	QQQ	ETF	43.06	43.06	42.87	42.95	1926401.0
2007-03-13 09:00:00	QQQ	ETF	42.96	43.03	42.94	43.0	1403201.0
2007-03-13 09:30:00	QQQ	ETF	43.0	43.24	42.93	43.13	19331200.0
2007-03-13 10:00:00	QQQ	ETF	43.13	43.16	43.0	43.14	8275400.0
2007-03-13 10:30:00	QQQ	ETF	43.15	43.2	43.07	43.15	8282400.0
2007-03-13 11:00:00	QQQ	ETF	43.15	43.2	43.06	43.06	5427200.0
2007-03-13 11:30:00	QQQ	ETF	43.06	43.1	42.98	43.03	4622900.0
2007-03-13 12:00:00	QQQ	ETF	43.03	43.07	42.68	42.7	15152700.0
2007-03-13 12:30:00	QQQ	ETF	42.7	42.81	42.6	42.71	12295800.0
2007-03-13 13:00:00	QQQ	ETF	42.71	42.8	42.7	42.73	5284300.0
2007-03-13 13:30:00	QQQ	ETF	42.73	42.75	42.61	42.72	13106300.0
2007-03-13 14:00:00	QQQ	ETF	42.71	42.74	42.47	42.56	15216400.0
2007-03-13 14:30:00	QQQ	ETF	42.55	42.71	42.54	42.56	9359900.0
2007-03-13 15:00:00	QQQ	ETF	42.56	42.7	42.47	42.6	13936600.0
2007-03-13 15:30:00	QQQ	ETF	42.6	42.62	42.37	42.37	24217300.0
2007-03-13 16:00:00	QQQ	ETF	42.36	42.6401	42.27	42.41	5747572.0
2007-03-13 16:30:00	QQQ	ETF	42.4	42.4	42.36	42.37	174038.0

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

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