PREVIEW / etf_30min / 2009-09-02

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-09-02.parquet
  size:    227 KB
  rows:    7,512

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
2009-09-02 04:00:00	SPY	ETF	99.91	99.91	99.83	99.89	8100.0
2009-09-02 04:30:00	SPY	ETF	99.89	99.93	99.89	99.93	450.0
2009-09-02 05:00:00	SPY	ETF	100.1	100.11	100.09	100.09	10000.0
2009-09-02 05:30:00	SPY	ETF	100.03	100.03	99.85	99.85	700.0
2009-09-02 06:00:00	SPY	ETF	99.96	100.11	99.96	100.11	30900.0
2009-09-02 06:30:00	SPY	ETF	100.04	100.05	100.03	100.03	8461.0
2009-09-02 07:00:00	SPY	ETF	100.1	100.13	100.05	100.1	19594.0
2009-09-02 07:30:00	SPY	ETF	100.1	100.18	100.08	100.08	97000.0
2009-09-02 08:00:00	SPY	ETF	100.06	100.14	99.7	99.93	2406712.0
2009-09-02 08:30:00	SPY	ETF	99.95	100.2	99.67	99.8	1584205.0
2009-09-02 09:00:00	SPY	ETF	99.81	99.88	99.69	99.78	1726561.0
2009-09-02 09:30:00	SPY	ETF	99.78	100.31	99.67	100.02	25377968.0
2009-09-02 10:00:00	SPY	ETF	100.01	100.19	99.79	99.84	19063859.0
2009-09-02 10:30:00	SPY	ETF	99.84	100.42	99.57	100.35	17618050.0
2009-09-02 11:00:00	SPY	ETF	100.36	100.37	100.09	100.35	9008380.0
2009-09-02 11:30:00	SPY	ETF	100.35	100.44	100.09	100.125	9029928.0
2009-09-02 12:00:00	SPY	ETF	100.13	100.3	100.0	100.23	7288458.0
2009-09-02 12:30:00	SPY	ETF	100.23	100.37	100.19	100.3	4786947.0
2009-09-02 13:00:00	SPY	ETF	100.29	100.33	100.11	100.24	4751906.0
2009-09-02 13:30:00	SPY	ETF	100.24	100.26	100.07	100.1	4147806.0
2009-09-02 14:00:00	SPY	ETF	100.1	100.25	100.03	100.19	6524984.0
2009-09-02 14:30:00	SPY	ETF	100.19	100.38	100.11	100.15	8998794.0
2009-09-02 15:00:00	SPY	ETF	100.14	100.41	100.03	100.18	11217768.0
2009-09-02 15:30:00	SPY	ETF	100.18	100.35	99.81	99.84	21323468.0
2009-09-02 16:00:00	SPY	ETF	99.83	100.37	99.77	99.87	6798315.0
2009-09-02 16:30:00	SPY	ETF	99.87	100.2116	99.84	99.87	2245608.0
2009-09-02 17:00:00	SPY	ETF	99.86	99.86	99.82	99.85	22639.0
2009-09-02 17:30:00	SPY	ETF	99.85	99.85	99.8	99.8	91391.0
2009-09-02 18:00:00	SPY	ETF	99.82	99.87	99.78	99.81	110189.0
2009-09-02 18:30:00	SPY	ETF	99.81	99.87	99.8	99.85	27319.0
2009-09-02 19:00:00	SPY	ETF	99.83	99.85	99.81	99.85	11113.0
2009-09-02 19:30:00	SPY	ETF	99.85	99.96	99.84	99.91	60624.0
2009-09-02 04:00:00	QQQ	ETF	39.1	39.12	39.07	39.09	10600.0
2009-09-02 04:30:00	QQQ	ETF	39.15	39.15	39.15	39.15	100.0
2009-09-02 05:00:00	QQQ	ETF	39.21	39.21	39.21	39.21	5000.0
2009-09-02 05:30:00	QQQ	ETF	39.18	39.18	39.11	39.11	6100.0
2009-09-02 06:00:00	QQQ	ETF	39.13	39.13	39.13	39.13	2500.0
2009-09-02 06:30:00	QQQ	ETF	39.18	39.18	39.15	39.15	1100.0
2009-09-02 07:00:00	QQQ	ETF	39.22	39.23	39.2	39.2	143667.0
2009-09-02 07:30:00	QQQ	ETF	39.22	39.26	39.22	39.23	29800.0
2009-09-02 08:00:00	QQQ	ETF	39.21	39.26	39.05	39.23	323738.0
2009-09-02 08:30:00	QQQ	ETF	39.23	39.23	39.1	39.14	431337.0
2009-09-02 09:00:00	QQQ	ETF	39.15	39.21	39.09	39.1	1552073.0
2009-09-02 09:30:00	QQQ	ETF	39.09	39.47	39.04	39.28	15889219.0
2009-09-02 10:00:00	QQQ	ETF	39.28	39.37	39.17	39.19	14059372.0
2009-09-02 10:30:00	QQQ	ETF	39.1901	39.44	39.12	39.42	7418083.0
2009-09-02 11:00:00	QQQ	ETF	39.43	39.44	39.32	39.44	5779835.0
2009-09-02 11:30:00	QQQ	ETF	39.44	39.47	39.33	39.35	4701061.0
2009-09-02 12:00:00	QQQ	ETF	39.34	39.43	39.27	39.38	4726803.0
2009-09-02 12:30:00	QQQ	ETF	39.39	39.4404	39.38	39.3805	2875743.0

> showing 50 of 7,512 rows — these rows as CSV

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