PREVIEW / etf_30min / 2007-10-02

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-10-02.parquet
  size:    124 KB
  rows:    4,791

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-10-02 04:30:00	SPY	ETF	154.35	154.35	154.35	154.35	30000.0
2007-10-02 05:30:00	SPY	ETF	154.3	154.43	154.3	154.43	20000.0
2007-10-02 06:00:00	SPY	ETF	154.48	154.56	154.44	154.56	12500.0
2007-10-02 06:30:00	SPY	ETF	154.5	154.6	154.45	154.6	143000.0
2007-10-02 07:00:00	SPY	ETF	154.63	154.64	154.51	154.56	261700.0
2007-10-02 07:30:00	SPY	ETF	154.54	154.68	154.52	154.64	134900.0
2007-10-02 08:00:00	SPY	ETF	154.62	154.63	154.43	154.43	155200.0
2007-10-02 08:30:00	SPY	ETF	154.45	154.62	154.36	154.57	680300.0
2007-10-02 09:00:00	SPY	ETF	154.58	154.61	154.48	154.6	284500.0
2007-10-02 09:30:00	SPY	ETF	154.61	154.65	154.3	154.33	11842720.0
2007-10-02 10:00:00	SPY	ETF	154.325	154.54	154.13	154.19	15251700.0
2007-10-02 10:30:00	SPY	ETF	154.19	154.21	153.95	154.15	14155600.0
2007-10-02 11:00:00	SPY	ETF	154.15	154.24	153.95	154.24	9334900.0
2007-10-02 11:30:00	SPY	ETF	154.23	154.3	154.11	154.24	6858000.0
2007-10-02 12:00:00	SPY	ETF	154.24	154.3	154.06	154.14	2454400.0
2007-10-02 12:30:00	SPY	ETF	154.14	154.25	153.9	154.05	5754800.0
2007-10-02 13:00:00	SPY	ETF	154.05	154.11	153.81	153.84	4786300.0
2007-10-02 13:30:00	SPY	ETF	153.84	154.16	153.83	154.1	3943400.0
2007-10-02 14:00:00	SPY	ETF	154.1	154.35	154.02	154.31	5704450.0
2007-10-02 14:30:00	SPY	ETF	154.3	154.46	154.24	154.36	8689799.0
2007-10-02 15:00:00	SPY	ETF	154.37	154.38	154.2	154.25	5984200.0
2007-10-02 15:30:00	SPY	ETF	154.25	154.5	154.18	154.43	9924500.0
2007-10-02 16:00:00	SPY	ETF	154.44	154.44	154.1	154.15	3907400.0
2007-10-02 16:30:00	SPY	ETF	154.12	154.43	154.01	154.14	197300.0
2007-10-02 17:00:00	SPY	ETF	154.15	154.17	154.06	154.17	61600.0
2007-10-02 17:30:00	SPY	ETF	154.15	154.18	154.15	154.18	300.0
2007-10-02 18:00:00	SPY	ETF	154.15	154.21	154.15	154.21	40800.0
2007-10-02 18:30:00	SPY	ETF	154.21	154.21	154.09	154.21	251700.0
2007-10-02 19:00:00	SPY	ETF	154.18	154.21	154.13	154.2	32600.0
2007-10-02 19:30:00	SPY	ETF	154.15	154.21	154.15	154.21	6300.0
2007-10-02 04:30:00	QQQ	ETF	51.91	51.91	51.91	51.91	1000.0
2007-10-02 05:00:00	QQQ	ETF	52.03	52.03	52.03	52.03	1700.0
2007-10-02 05:30:00	QQQ	ETF	52.0	52.0	52.0	52.0	10000.0
2007-10-02 06:00:00	QQQ	ETF	52.04	52.04	52.04	52.04	10000.0
2007-10-02 07:00:00	QQQ	ETF	52.06	52.06	52.03	52.04	36900.0
2007-10-02 07:30:00	QQQ	ETF	52.04	52.08	52.04	52.04	135970.0
2007-10-02 08:00:00	QQQ	ETF	52.05	52.06	51.98	51.99	281225.0
2007-10-02 08:30:00	QQQ	ETF	51.98	52.02	51.95	52.02	825820.0
2007-10-02 09:00:00	QQQ	ETF	52.02	52.05	51.99	52.04	426651.0
2007-10-02 09:30:00	QQQ	ETF	52.04	52.06	51.87	51.88	9927323.0
2007-10-02 10:00:00	QQQ	ETF	51.88	52.03	51.84	51.87	8034286.0
2007-10-02 10:30:00	QQQ	ETF	51.87	51.89	51.78	51.84	5962866.0
2007-10-02 11:00:00	QQQ	ETF	51.83	51.87	51.72	51.8606	4839778.0
2007-10-02 11:30:00	QQQ	ETF	51.86	51.91	51.82	51.91	3101023.0
2007-10-02 12:00:00	QQQ	ETF	51.9	51.91	51.83	51.8401	2275718.0
2007-10-02 12:30:00	QQQ	ETF	51.84	51.85	51.74	51.84	3370805.0
2007-10-02 13:00:00	QQQ	ETF	51.84	51.87	51.76	51.78	2906588.0
2007-10-02 13:30:00	QQQ	ETF	51.78	51.9	51.77	51.88	3209877.0
2007-10-02 14:00:00	QQQ	ETF	51.88	51.95	51.85	51.93	2670825.0
2007-10-02 14:30:00	QQQ	ETF	51.93	52.0	51.9	51.94	3494944.0

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

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