PREVIEW / etf_30min / 2007-03-30

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-03-30.parquet
  size:    106 KB
  rows:    3,613

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-30 06:30:00	SPY	ETF	141.98	142.04	141.98	142.04	6000.0
2007-03-30 07:00:00	SPY	ETF	142.01	142.06	142.01	142.04	26400.0
2007-03-30 07:30:00	SPY	ETF	142.08	142.24	142.04	142.2	266400.0
2007-03-30 08:00:00	SPY	ETF	142.04	142.31	142.04	142.17	747100.0
2007-03-30 08:30:00	SPY	ETF	142.17	142.49	141.91	142.31	2419300.0
2007-03-30 09:00:00	SPY	ETF	142.33	142.42	142.15	142.17	1685880.0
2007-03-30 09:30:00	SPY	ETF	142.17	142.84	142.12	142.56	14132595.0
2007-03-30 10:00:00	SPY	ETF	142.57	142.77	142.33	142.4	8908393.0
2007-03-30 10:30:00	SPY	ETF	142.4	142.47	142.19	142.37	5354502.0
2007-03-30 11:00:00	SPY	ETF	142.36	142.44	141.61	141.7	9521705.0
2007-03-30 11:30:00	SPY	ETF	141.7	141.9	140.56	141.52	25243000.0
2007-03-30 12:00:00	SPY	ETF	141.48	141.68	141.28	141.44	10453175.0
2007-03-30 12:30:00	SPY	ETF	141.45	141.73	141.39	141.48	6427750.0
2007-03-30 13:00:00	SPY	ETF	141.47	141.73	141.45	141.72	3720100.0
2007-03-30 13:30:00	SPY	ETF	141.72	142.6	141.59	141.76	4676500.0
2007-03-30 14:00:00	SPY	ETF	141.76	142.06	141.7	142.0	4033750.0
2007-03-30 14:30:00	SPY	ETF	142.0	142.24	141.95	142.06	6540816.0
2007-03-30 15:00:00	SPY	ETF	142.06	142.15	141.87	141.99	3184075.0
2007-03-30 15:30:00	SPY	ETF	141.99	142.06	141.77	141.94	10016139.0
2007-03-30 16:00:00	SPY	ETF	141.93	142.11	141.9	142.04	4609800.0
2007-03-30 16:30:00	SPY	ETF	142.04	142.07	141.97	142.0	552200.0
2007-03-30 17:00:00	SPY	ETF	142.02	142.06	142.02	142.05	53300.0
2007-03-30 17:30:00	SPY	ETF	142.05	142.05	142.01	142.01	8900.0
2007-03-30 18:00:00	SPY	ETF	142.03	142.03	142.03	142.03	100.0
2007-03-30 18:30:00	SPY	ETF	142.02	142.02	142.0	142.0	6200.0
2007-03-30 19:00:00	SPY	ETF	142.0	142.0	142.0	142.0	400.0
2007-03-30 06:30:00	QQQ	ETF	43.5	43.5	43.5	43.5	3327.0
2007-03-30 07:00:00	QQQ	ETF	43.5	43.52	43.45	43.52	132467.0
2007-03-30 07:30:00	QQQ	ETF	43.51	43.56	43.5	43.54	191865.0
2007-03-30 08:00:00	QQQ	ETF	43.55	43.6	43.51	43.55	393547.0
2007-03-30 08:30:00	QQQ	ETF	43.55	43.73	43.44	43.6	1513908.0
2007-03-30 09:00:00	QQQ	ETF	43.6	43.64	43.56	43.57	702027.0
2007-03-30 09:30:00	QQQ	ETF	43.57	43.87	43.55	43.7	16768000.0
2007-03-30 10:00:00	QQQ	ETF	43.7	43.76	43.59	43.64	9512900.0
2007-03-30 10:30:00	QQQ	ETF	43.64	43.72	43.58	43.7	6559500.0
2007-03-30 11:00:00	QQQ	ETF	43.69	43.73	43.49	43.52	7357500.0
2007-03-30 11:30:00	QQQ	ETF	43.51	43.56	43.22	43.47	22861900.0
2007-03-30 12:00:00	QQQ	ETF	43.48	43.49	43.35	43.42	8350900.0
2007-03-30 12:30:00	QQQ	ETF	43.42	43.52	43.38	43.41	4498200.0
2007-03-30 13:00:00	QQQ	ETF	43.41	43.52	43.39	43.51	3178400.0
2007-03-30 13:30:00	QQQ	ETF	43.51	43.63	43.48	43.54	8328900.0
2007-03-30 14:00:00	QQQ	ETF	43.54	43.65	43.5	43.63	3216600.0
2007-03-30 14:30:00	QQQ	ETF	43.63	43.71	43.58	43.62	5195800.0
2007-03-30 15:00:00	QQQ	ETF	43.62	43.63	43.54	43.58	3442700.0
2007-03-30 15:30:00	QQQ	ETF	43.58	43.63	43.51	43.55	10457800.0
2007-03-30 16:00:00	QQQ	ETF	43.54	43.65	43.52	43.62	6907621.0
2007-03-30 16:30:00	QQQ	ETF	43.62	43.62	43.53	43.58	127200.0
2007-03-30 17:00:00	QQQ	ETF	43.58	43.59	43.56	43.56	69900.0
2007-03-30 17:30:00	QQQ	ETF	43.55	43.58	43.52	43.53	21423.0
2007-03-30 18:00:00	QQQ	ETF	43.57	43.59	43.54	43.54	9150.0

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

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