PREVIEW / etf_30min / 2007-02-27

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-02-27.parquet
  size:    118 KB
  rows:    3,973

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-02-27 04:00:00	SPY	ETF	144.52	144.52	144.52	144.52	2300.0
2007-02-27 04:30:00	SPY	ETF	144.47	144.47	144.47	144.47	1600.0
2007-02-27 06:00:00	SPY	ETF	144.6	144.6	144.49	144.5	125000.0
2007-02-27 06:30:00	SPY	ETF	144.51	144.57	144.44	144.48	178300.0
2007-02-27 07:00:00	SPY	ETF	144.5	144.5	144.2	144.23	519400.0
2007-02-27 07:30:00	SPY	ETF	144.23	144.34	144.15	144.32	788100.0
2007-02-27 08:00:00	SPY	ETF	144.29	144.58	144.25	144.27	1210200.0
2007-02-27 08:30:00	SPY	ETF	144.26	144.28	143.89	143.93	2418100.0
2007-02-27 09:00:00	SPY	ETF	143.94	144.0	143.73	143.9	2734100.0
2007-02-27 09:30:00	SPY	ETF	143.88	144.2	143.31	143.58	23548800.0
2007-02-27 10:00:00	SPY	ETF	143.59	144.2	143.47	143.62	16697400.0
2007-02-27 10:30:00	SPY	ETF	143.62	143.84	143.44	143.44	8441000.0
2007-02-27 11:00:00	SPY	ETF	143.45	143.63	143.26	143.32	7938000.0
2007-02-27 11:30:00	SPY	ETF	143.31	143.6	143.15	143.18	7990600.0
2007-02-27 12:00:00	SPY	ETF	143.18	143.21	142.65	142.91	17007100.0
2007-02-27 12:30:00	SPY	ETF	142.9	143.06	142.84	142.92	5451800.0
2007-02-27 13:00:00	SPY	ETF	142.9099	142.98	142.6	142.61	6570300.0
2007-02-27 13:30:00	SPY	ETF	142.64	142.68	142.27	142.37	18534900.0
2007-02-27 14:00:00	SPY	ETF	142.37	142.4	141.05	141.18	22976100.0
2007-02-27 14:30:00	SPY	ETF	141.18	141.63	139.1	139.98	31765700.0
2007-02-27 15:00:00	SPY	ETF	139.98	141.36	139.0	140.68	46033400.0
2007-02-27 15:30:00	SPY	ETF	140.68	141.15	140.0	140.005	24774000.0
2007-02-27 16:00:00	SPY	ETF	140.0422	140.31	139.48	139.6	4472400.0
2007-02-27 16:30:00	SPY	ETF	139.6	139.65	139.1	139.3	947900.0
2007-02-27 17:00:00	SPY	ETF	139.27	139.35	139.14	139.28	386100.0
2007-02-27 17:30:00	SPY	ETF	139.25	140.1	139.1	139.36	2105200.0
2007-02-27 18:00:00	SPY	ETF	139.36	139.61	139.34	139.55	410200.0
2007-02-27 18:30:00	SPY	ETF	139.61	139.75	139.4	139.4	19900.0
2007-02-27 19:00:00	SPY	ETF	139.4	139.46	139.38	139.46	3200.0
2007-02-27 19:30:00	SPY	ETF	139.67	139.75	139.54	139.54	28600.0
2007-02-27 04:00:00	QQQ	ETF	44.77	44.77	44.71	44.71	3600.0
2007-02-27 04:30:00	QQQ	ETF	44.72	44.72	44.72	44.72	100.0
2007-02-27 06:30:00	QQQ	ETF	44.67	44.67	44.67	44.67	2500.0
2007-02-27 07:00:00	QQQ	ETF	44.7	44.71	44.63	44.63	270247.0
2007-02-27 07:30:00	QQQ	ETF	44.62	44.64	44.57	44.61	833240.0
2007-02-27 08:00:00	QQQ	ETF	44.61	44.64	44.54	44.54	1981250.0
2007-02-27 08:30:00	QQQ	ETF	44.55	44.55	44.37	44.38	2344513.0
2007-02-27 09:00:00	QQQ	ETF	44.38	44.42	44.3	44.36	1944862.0
2007-02-27 09:30:00	QQQ	ETF	44.36	44.4	44.08	44.36	29064600.0
2007-02-27 10:00:00	QQQ	ETF	44.36	44.43	44.3	44.4	18359200.0
2007-02-27 10:30:00	QQQ	ETF	44.4	44.48	44.28	44.29	12842600.0
2007-02-27 11:00:00	QQQ	ETF	44.3	44.32	44.2	44.24	10917600.0
2007-02-27 11:30:00	QQQ	ETF	44.23	44.38	44.15	44.15	13515100.0
2007-02-27 12:00:00	QQQ	ETF	44.15	44.16	43.91	44.0	28726700.0
2007-02-27 12:30:00	QQQ	ETF	43.99	44.14	43.98	44.03	12388100.0
2007-02-27 13:00:00	QQQ	ETF	44.04	44.04	43.89	43.9	15838400.0
2007-02-27 13:30:00	QQQ	ETF	43.89	43.95	43.77	43.78	17133800.0
2007-02-27 14:00:00	QQQ	ETF	43.78	43.81	43.38	43.41	29558600.0
2007-02-27 14:30:00	QQQ	ETF	43.41	43.64	43.14	43.28	38492100.0
2007-02-27 15:00:00	QQQ	ETF	43.28	43.71	43.06	43.47	46953900.0

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

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