PREVIEW / etf_30min / 2007-03-01

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-03-01.parquet
  size:    108 KB
  rows:    3,632

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-01 04:00:00	SPY	ETF	141.0	141.0	141.0	141.0	1000.0
2007-03-01 04:30:00	SPY	ETF	141.21	141.36	141.21	141.36	1100.0
2007-03-01 05:00:00	SPY	ETF	141.22	141.45	141.22	141.45	500.0
2007-03-01 06:00:00	SPY	ETF	141.19	141.19	141.19	141.19	15000.0
2007-03-01 06:30:00	SPY	ETF	141.06	141.06	140.9	140.9	23000.0
2007-03-01 07:00:00	SPY	ETF	140.98	140.98	140.56	140.56	127000.0
2007-03-01 07:30:00	SPY	ETF	140.57	140.61	139.75	139.75	3711800.0
2007-03-01 08:00:00	SPY	ETF	139.75	141.25	139.32	139.4	5545300.0
2007-03-01 08:30:00	SPY	ETF	139.4	141.1	139.19	139.73	7769900.0
2007-03-01 09:00:00	SPY	ETF	139.74	139.78	139.1	139.37	4416200.0
2007-03-01 09:30:00	SPY	ETF	139.34	139.42	138.05	138.84	32160110.0
2007-03-01 10:00:00	SPY	ETF	138.84	140.59	138.77	140.31	39422942.0
2007-03-01 10:30:00	SPY	ETF	140.39	141.0	139.92	140.35	22099329.0
2007-03-01 11:00:00	SPY	ETF	140.36	141.01	140.17	140.9	17074130.0
2007-03-01 11:30:00	SPY	ETF	140.9	141.16	140.4	140.48	12777739.0
2007-03-01 12:00:00	SPY	ETF	140.48	140.71	140.24	140.49	6484837.0
2007-03-01 12:30:00	SPY	ETF	140.5	140.85	140.36	140.78	4490709.0
2007-03-01 13:00:00	SPY	ETF	140.78	140.9	140.41	140.68	3798700.0
2007-03-01 13:30:00	SPY	ETF	140.68	140.94	140.3	140.88	5120100.0
2007-03-01 14:00:00	SPY	ETF	140.92	141.25	140.77	140.78	8727800.0
2007-03-01 14:30:00	SPY	ETF	140.78	141.24	140.72	141.08	6851200.0
2007-03-01 15:00:00	SPY	ETF	141.09	141.13	140.3	140.56	11674000.0
2007-03-01 15:30:00	SPY	ETF	140.56	140.73	140.38	140.59	10657200.0
2007-03-01 16:00:00	SPY	ETF	140.59	140.67	140.51	140.56	1685400.0
2007-03-01 16:30:00	SPY	ETF	140.6	140.6	140.53	140.6	101000.0
2007-03-01 17:00:00	SPY	ETF	140.54	140.56	140.51	140.51	47100.0
2007-03-01 17:30:00	SPY	ETF	140.52	140.56	140.51	140.52	34500.0
2007-03-01 18:00:00	SPY	ETF	140.55	140.61	140.55	140.61	12000.0
2007-03-01 19:00:00	SPY	ETF	140.64	140.85	140.64	140.85	8800.0
2007-03-01 19:30:00	SPY	ETF	140.61	140.63	140.56	140.56	3600.0
2007-03-01 04:30:00	QQQ	ETF	43.47	43.47	43.47	43.47	1835.0
2007-03-01 06:30:00	QQQ	ETF	43.45	43.45	43.45	43.45	100.0
2007-03-01 07:00:00	QQQ	ETF	43.35	43.36	43.21	43.23	397743.0
2007-03-01 07:30:00	QQQ	ETF	43.22	43.25	42.85	42.85	1462522.0
2007-03-01 08:00:00	QQQ	ETF	42.87	43.55	42.56	42.62	3938544.0
2007-03-01 08:30:00	QQQ	ETF	42.63	43.51	42.55	42.7	4051813.0
2007-03-01 09:00:00	QQQ	ETF	42.7	42.72	42.45	42.55	3490721.0
2007-03-01 09:30:00	QQQ	ETF	42.55	42.77	42.24	42.7	46466600.0
2007-03-01 10:00:00	QQQ	ETF	42.7	43.15	42.69	43.07	33093400.0
2007-03-01 10:30:00	QQQ	ETF	43.07	43.28	42.9	43.14	22028500.0
2007-03-01 11:00:00	QQQ	ETF	43.14	43.39	42.96	43.3	22498200.0
2007-03-01 11:30:00	QQQ	ETF	43.29	43.43	43.11	43.18	14000500.0
2007-03-01 12:00:00	QQQ	ETF	43.18	43.24	43.05	43.13	10123300.0
2007-03-01 12:30:00	QQQ	ETF	43.13	43.31	43.11	43.3	6088600.0
2007-03-01 13:00:00	QQQ	ETF	43.29	43.34	43.1	43.25	4597500.0
2007-03-01 13:30:00	QQQ	ETF	43.25	43.38	43.16	43.32	5059700.0
2007-03-01 14:00:00	QQQ	ETF	43.37	43.54	43.29	43.29	12419900.0
2007-03-01 14:30:00	QQQ	ETF	43.29	43.47	43.27	43.41	6754900.0
2007-03-01 15:00:00	QQQ	ETF	43.42	43.43	43.11	43.17	16030500.0
2007-03-01 15:30:00	QQQ	ETF	43.17	43.23	43.08	43.13	16005100.0

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

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