PREVIEW / etf_30min / 2007-10-01

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-10-01.parquet
  size:    132 KB
  rows:    4,884

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-01 05:30:00	SPY	ETF	152.75	152.75	152.67	152.68	47000.0
2007-10-01 06:00:00	SPY	ETF	152.71	152.85	152.71	152.85	12000.0
2007-10-01 06:30:00	SPY	ETF	152.88	152.97	152.88	152.97	78000.0
2007-10-01 07:00:00	SPY	ETF	152.91	152.91	152.38	152.48	1041300.0
2007-10-01 07:30:00	SPY	ETF	152.52	152.56	152.4	152.5	191400.0
2007-10-01 08:00:00	SPY	ETF	152.47	152.6	152.4	152.55	816800.0
2007-10-01 08:30:00	SPY	ETF	152.6	152.68	152.29	152.64	323200.0
2007-10-01 09:00:00	SPY	ETF	152.64	152.71	152.58	152.61	405500.0
2007-10-01 09:30:00	SPY	ETF	152.6	153.35	152.5	153.16	18851480.0
2007-10-01 10:00:00	SPY	ETF	153.16	153.64	153.12	153.4	16073800.0
2007-10-01 10:30:00	SPY	ETF	153.4	153.57	153.33	153.48	8977500.0
2007-10-01 11:00:00	SPY	ETF	153.47	153.64	153.35	153.49	6971500.0
2007-10-01 11:30:00	SPY	ETF	153.49	154.07	153.49	154.0	14107000.0
2007-10-01 12:00:00	SPY	ETF	154.01	154.22	153.93	154.09	9855600.0
2007-10-01 12:30:00	SPY	ETF	154.09	154.11	153.95	153.97	5251200.0
2007-10-01 13:00:00	SPY	ETF	153.97	154.44	153.97	154.35	7566700.0
2007-10-01 13:30:00	SPY	ETF	154.36	154.54	154.3	154.38	10547800.0
2007-10-01 14:00:00	SPY	ETF	154.39	154.6	154.38	154.39	6485700.0
2007-10-01 14:30:00	SPY	ETF	154.39	154.68	154.36	154.6	6078000.0
2007-10-01 15:00:00	SPY	ETF	154.6	154.75	154.46	154.55	6905200.0
2007-10-01 15:30:00	SPY	ETF	154.54	154.57	152.5	154.52	12329900.0
2007-10-01 16:00:00	SPY	ETF	154.52	154.55	154.29	154.31	3541300.0
2007-10-01 16:30:00	SPY	ETF	154.31	154.32	154.22	154.3	3757200.0
2007-10-01 17:00:00	SPY	ETF	154.24	154.26	152.48	154.19	3154200.0
2007-10-01 17:30:00	SPY	ETF	154.27	154.31	153.35	154.19	1777900.0
2007-10-01 18:00:00	SPY	ETF	154.2	154.21	154.17	154.17	17300.0
2007-10-01 18:30:00	SPY	ETF	154.16	154.2	154.1	154.2	40000.0
2007-10-01 19:00:00	SPY	ETF	154.25	154.27	154.23	154.27	6100.0
2007-10-01 06:00:00	QQQ	ETF	51.49	51.49	51.49	51.49	2000.0
2007-10-01 07:00:00	QQQ	ETF	51.49	51.49	51.37	51.41	130400.0
2007-10-01 07:30:00	QQQ	ETF	51.42	51.45	51.4	51.4	35100.0
2007-10-01 08:00:00	QQQ	ETF	51.4	51.43	51.38	51.41	433943.0
2007-10-01 08:30:00	QQQ	ETF	51.43	51.47	51.41	51.43	345185.0
2007-10-01 09:00:00	QQQ	ETF	51.43	51.46	51.41	51.46	874193.0
2007-10-01 09:30:00	QQQ	ETF	51.45	51.64	51.38	51.56	12405695.0
2007-10-01 10:00:00	QQQ	ETF	51.56	51.66	51.51	51.54	7580576.0
2007-10-01 10:30:00	QQQ	ETF	51.53	51.6	51.51	51.58	6623830.0
2007-10-01 11:00:00	QQQ	ETF	51.57	51.64	51.54	51.6	4267985.0
2007-10-01 11:30:00	QQQ	ETF	51.6	51.82	51.6	51.8185	7882405.0
2007-10-01 12:00:00	QQQ	ETF	51.82	51.94	51.78	51.882	4954963.0
2007-10-01 12:30:00	QQQ	ETF	51.88	51.89	51.85	51.86	2041736.0
2007-10-01 13:00:00	QQQ	ETF	51.86	52.01	51.86	51.988	6381750.0
2007-10-01 13:30:00	QQQ	ETF	51.9805	52.03	51.96	51.98	4402010.0
2007-10-01 14:00:00	QQQ	ETF	51.98	52.09	51.98	52.0	7861128.0
2007-10-01 14:30:00	QQQ	ETF	52.0	52.16	52.0	52.1	7921049.0
2007-10-01 15:00:00	QQQ	ETF	52.11	52.14	52.03	52.06	5388171.0
2007-10-01 15:30:00	QQQ	ETF	52.06	52.07	51.88	52.02	17675580.0
2007-10-01 16:00:00	QQQ	ETF	52.01	52.0435	51.4076	51.96	5868603.0
2007-10-01 16:30:00	QQQ	ETF	51.96	51.97	51.92	51.94	96349.0
2007-10-01 17:00:00	QQQ	ETF	51.93	51.95	51.92	51.92	26066.0

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

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