PREVIEW / etf_30min / 2007-08-02

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-08-02.parquet
  size:    131 KB
  rows:    4,814

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-02 04:00:00	SPY	ETF	146.45	146.45	146.45	146.45	100.0
2007-08-02 05:00:00	SPY	ETF	146.05	146.06	146.05	146.06	1500.0
2007-08-02 05:30:00	SPY	ETF	146.22	146.36	146.22	146.36	10500.0
2007-08-02 06:00:00	SPY	ETF	146.29	146.66	146.21	146.66	23200.0
2007-08-02 06:30:00	SPY	ETF	146.64	146.64	146.33	146.33	20000.0
2007-08-02 07:00:00	SPY	ETF	146.36	146.89	146.36	146.88	420100.0
2007-08-02 07:30:00	SPY	ETF	146.88	146.97	146.63	146.84	742300.0
2007-08-02 08:00:00	SPY	ETF	146.88	147.12	146.3	146.84	5528600.0
2007-08-02 08:30:00	SPY	ETF	146.84	147.33	146.8	147.25	6173300.0
2007-08-02 09:00:00	SPY	ETF	147.23	147.23	146.76	146.77	1694560.0
2007-08-02 09:30:00	SPY	ETF	146.77	147.42	146.72	147.26	34415813.0
2007-08-02 10:00:00	SPY	ETF	147.27	147.28	146.52	146.78	25129681.0
2007-08-02 10:30:00	SPY	ETF	146.78	147.0	146.49	146.51	17492912.0
2007-08-02 11:00:00	SPY	ETF	146.52	146.84	146.1	146.8	17399812.0
2007-08-02 11:30:00	SPY	ETF	146.79	147.26	146.56	147.24	14375015.0
2007-08-02 12:00:00	SPY	ETF	147.24	147.45	146.95	147.03	16621091.0
2007-08-02 12:30:00	SPY	ETF	147.02	147.15	146.81	146.83	9546259.0
2007-08-02 13:00:00	SPY	ETF	146.83	147.02	145.26	146.43	22428991.0
2007-08-02 13:30:00	SPY	ETF	146.44	146.93	146.43	146.73	13220546.0
2007-08-02 14:00:00	SPY	ETF	146.74	147.04	146.43	146.53	17074157.0
2007-08-02 14:30:00	SPY	ETF	146.53	147.185	146.15	146.35	19110070.0
2007-08-02 15:00:00	SPY	ETF	146.36	147.71	146.2	147.62	28940385.0
2007-08-02 15:30:00	SPY	ETF	147.63	147.76	147.05	147.28	32261061.0
2007-08-02 16:00:00	SPY	ETF	147.33	147.7	146.2785	147.56	7332700.0
2007-08-02 16:30:00	SPY	ETF	147.58	147.67	146.43	146.9199	318300.0
2007-08-02 17:00:00	SPY	ETF	147.62	147.65	146.4101	147.45	83300.0
2007-08-02 17:30:00	SPY	ETF	146.8501	147.53	146.26	147.53	201900.0
2007-08-02 18:00:00	SPY	ETF	147.48	147.65	147.48	147.59	40200.0
2007-08-02 18:30:00	SPY	ETF	147.55	147.61	146.6201	147.2415	18700.0
2007-08-02 19:00:00	SPY	ETF	147.64	147.64	147.53	147.53	1500.0
2007-08-02 19:30:00	SPY	ETF	147.54	147.6	147.53	147.59	71100.0
2007-08-02 04:30:00	QQQ	ETF	47.74	47.74	47.74	47.74	5000.0
2007-08-02 06:30:00	QQQ	ETF	47.96	47.97	47.85	47.85	15650.0
2007-08-02 07:00:00	QQQ	ETF	47.84	48.01	47.82	48.01	221300.0
2007-08-02 07:30:00	QQQ	ETF	48.01	48.08	48.0	48.05	154791.0
2007-08-02 08:00:00	QQQ	ETF	48.06	48.15	48.03	48.04	956481.0
2007-08-02 08:30:00	QQQ	ETF	48.03	48.18	48.03	48.15	1240866.0
2007-08-02 09:00:00	QQQ	ETF	48.15	48.15	47.94	47.94	1592797.0
2007-08-02 09:30:00	QQQ	ETF	47.94	48.2	47.86	48.08	38652911.0
2007-08-02 10:00:00	QQQ	ETF	48.07	48.09	47.83	47.93	17084685.0
2007-08-02 10:30:00	QQQ	ETF	47.9299	48.06	47.86	47.92	10721418.0
2007-08-02 11:00:00	QQQ	ETF	47.92	48.01	47.79	48.0	9957467.0
2007-08-02 11:30:00	QQQ	ETF	47.99	48.3	47.94	48.25	13976185.0
2007-08-02 12:00:00	QQQ	ETF	48.26	48.3	48.09	48.16	7962798.0
2007-08-02 12:30:00	QQQ	ETF	48.16	48.2	48.06	48.07	4516392.0
2007-08-02 13:00:00	QQQ	ETF	48.07	48.14	47.92	48.01	9710114.0
2007-08-02 13:30:00	QQQ	ETF	48.02	48.19	47.17	48.12	8222479.0
2007-08-02 14:00:00	QQQ	ETF	48.12	48.22	48.06	48.1	5704134.0
2007-08-02 14:30:00	QQQ	ETF	48.11	48.19	47.97	48.1	7746044.0
2007-08-02 15:00:00	QQQ	ETF	48.1	48.43	48.0	48.4	12876385.0

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

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