PREVIEW / etf_30min / 2007-07-02

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-07-02.parquet
  size:    116 KB
  rows:    4,490

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-07-02 05:00:00	SPY	ETF	150.41	150.41	150.41	150.41	100.0
2007-07-02 06:00:00	SPY	ETF	150.54	150.54	150.54	150.54	17500.0
2007-07-02 06:30:00	SPY	ETF	150.47	150.69	150.47	150.69	103600.0
2007-07-02 07:00:00	SPY	ETF	150.67	151.05	150.67	150.9	380500.0
2007-07-02 07:30:00	SPY	ETF	150.91	150.92	150.68	150.69	193100.0
2007-07-02 08:00:00	SPY	ETF	150.915	151.04	150.43	150.7	1813600.0
2007-07-02 08:30:00	SPY	ETF	150.71	150.91	150.68	150.72	873900.0
2007-07-02 09:00:00	SPY	ETF	150.71	151.04	150.43	150.82	2530600.0
2007-07-02 09:30:00	SPY	ETF	150.87	151.16	150.77	151.08	19713323.0
2007-07-02 10:00:00	SPY	ETF	151.09	151.54	151.09	151.21	14330351.0
2007-07-02 10:30:00	SPY	ETF	151.21	151.48	151.2	151.44	5833951.0
2007-07-02 11:00:00	SPY	ETF	151.44	151.55	151.22	151.36	6267702.0
2007-07-02 11:30:00	SPY	ETF	151.35	151.36	151.17	151.19	2112100.0
2007-07-02 12:00:00	SPY	ETF	151.19	151.47	151.05	151.13	4772593.0
2007-07-02 12:30:00	SPY	ETF	151.13	151.21	151.0	151.18	3333226.0
2007-07-02 13:00:00	SPY	ETF	151.18	151.37	151.14	151.2	3510662.0
2007-07-02 13:30:00	SPY	ETF	151.2	151.7	151.19	151.53	5340633.0
2007-07-02 14:00:00	SPY	ETF	151.53	151.59	151.39	151.43	3400847.0
2007-07-02 14:30:00	SPY	ETF	151.44	151.62	151.34	151.57	5008232.0
2007-07-02 15:00:00	SPY	ETF	151.57	151.6	151.24	151.585	6614503.0
2007-07-02 15:30:00	SPY	ETF	151.58	151.8	151.49	151.8	8436708.0
2007-07-02 16:00:00	SPY	ETF	151.81	151.91	151.73	151.78	3249900.0
2007-07-02 16:30:00	SPY	ETF	151.78	151.86	151.73	151.86	2255900.0
2007-07-02 17:00:00	SPY	ETF	151.87	151.88	151.79	151.8	210900.0
2007-07-02 17:30:00	SPY	ETF	151.78	151.82	151.76	151.82	101500.0
2007-07-02 18:00:00	SPY	ETF	151.8	151.82	151.78	151.78	23700.0
2007-07-02 19:00:00	SPY	ETF	151.85	151.85	151.84	151.85	5100.0
2007-07-02 19:30:00	SPY	ETF	151.89	151.89	151.89	151.89	200.0
2007-07-02 07:00:00	QQQ	ETF	47.7	47.76	47.7	47.74	419950.0
2007-07-02 07:30:00	QQQ	ETF	47.74	47.76	47.71	47.73	309372.0
2007-07-02 08:00:00	QQQ	ETF	47.71	47.74	47.57	47.71	1106968.0
2007-07-02 08:30:00	QQQ	ETF	47.71	47.74	47.57	47.71	237105.0
2007-07-02 09:00:00	QQQ	ETF	47.7	47.74	47.7	47.72	649350.0
2007-07-02 09:30:00	QQQ	ETF	47.71	47.9	47.68	47.87	13866541.0
2007-07-02 10:00:00	QQQ	ETF	47.87	47.97	47.86	47.9	13904827.0
2007-07-02 10:30:00	QQQ	ETF	47.9	48.01	47.895	47.99	8132498.0
2007-07-02 11:00:00	QQQ	ETF	47.99	48.03	47.95	47.9785	4595356.0
2007-07-02 11:30:00	QQQ	ETF	47.97	47.99	47.92	47.93	2115205.0
2007-07-02 12:00:00	QQQ	ETF	47.93	48.0	47.91	47.93	3197165.0
2007-07-02 12:30:00	QQQ	ETF	47.94	47.9505	47.9	47.95	1840969.0
2007-07-02 13:00:00	QQQ	ETF	47.95	47.99	47.93	47.9388	3676297.0
2007-07-02 13:30:00	QQQ	ETF	47.9389	48.03	47.93	47.99	2848318.0
2007-07-02 14:00:00	QQQ	ETF	47.99	48.01	47.9405	47.98	1194738.0
2007-07-02 14:30:00	QQQ	ETF	47.98	48.02	47.95	48.0	2482499.0
2007-07-02 15:00:00	QQQ	ETF	47.99	48.0	47.94	47.98	3096280.0
2007-07-02 15:30:00	QQQ	ETF	47.99	48.048	47.94	48.03	8930819.0
2007-07-02 16:00:00	QQQ	ETF	48.03	48.05	47.96	48.02	3993495.0
2007-07-02 16:30:00	QQQ	ETF	48.0	48.04	47.98	48.02	454693.0
2007-07-02 17:00:00	QQQ	ETF	48.04	48.04	48.0	48.0	245247.0
2007-07-02 17:30:00	QQQ	ETF	48.0	48.03	48.0	48.01	38894.0

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

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