PREVIEW / etf_30min / 2007-07-06

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-07-06.parquet
  size:    114 KB
  rows:    4,393

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-06 06:30:00	SPY	ETF	152.46	152.49	152.46	152.49	19500.0
2007-07-06 07:00:00	SPY	ETF	152.4	152.49	152.4	152.49	10300.0
2007-07-06 07:30:00	SPY	ETF	152.49	152.49	152.33	152.34	104700.0
2007-07-06 08:00:00	SPY	ETF	152.39	152.5	152.36	152.47	376700.0
2007-07-06 08:30:00	SPY	ETF	152.49	152.67	152.03	152.18	4207100.0
2007-07-06 09:00:00	SPY	ETF	152.24	152.43	152.17	152.38	903500.0
2007-07-06 09:30:00	SPY	ETF	152.38	152.44	151.93	152.08	11693204.0
2007-07-06 10:00:00	SPY	ETF	152.08	152.57	152.07	152.57	5832857.0
2007-07-06 10:30:00	SPY	ETF	152.57	152.62	152.32	152.39	8823830.0
2007-07-06 11:00:00	SPY	ETF	152.4	152.87	152.35	152.72	4273800.0
2007-07-06 11:30:00	SPY	ETF	152.72	152.89	152.66	152.69	4941800.0
2007-07-06 12:00:00	SPY	ETF	152.69	152.77	152.37	152.5	5284933.0
2007-07-06 12:30:00	SPY	ETF	152.5	152.63	152.43	152.61	2023536.0
2007-07-06 13:00:00	SPY	ETF	152.62	152.67	152.51	152.62	1578950.0
2007-07-06 13:30:00	SPY	ETF	152.6299	152.77	152.52	152.7	2965469.0
2007-07-06 14:00:00	SPY	ETF	152.7	152.92	152.63	152.81	3898665.0
2007-07-06 14:30:00	SPY	ETF	152.8	153.01	152.8	152.94	5022313.0
2007-07-06 15:00:00	SPY	ETF	152.93	153.11	152.93	153.07	3846893.0
2007-07-06 15:30:00	SPY	ETF	153.07	153.17	152.78	152.95	8136206.0
2007-07-06 16:00:00	SPY	ETF	152.96	153.1	152.84	153.0	2675000.0
2007-07-06 16:30:00	SPY	ETF	153.0	153.0	152.84	152.97	1643800.0
2007-07-06 17:00:00	SPY	ETF	152.97	152.97	152.9	152.9	317900.0
2007-07-06 17:30:00	SPY	ETF	152.9	152.96	152.9	152.96	2400.0
2007-07-06 18:30:00	SPY	ETF	152.96	152.96	152.96	152.96	500.0
2007-07-06 19:00:00	SPY	ETF	152.97	152.99	152.97	152.99	400.0
2007-07-06 19:30:00	SPY	ETF	152.95	152.95	152.92	152.95	1600.0
2007-07-06 05:30:00	QQQ	ETF	48.66	48.66	48.66	48.66	500.0
2007-07-06 06:30:00	QQQ	ETF	48.66	48.66	48.66	48.66	1600.0
2007-07-06 07:00:00	QQQ	ETF	48.65	48.71	48.65	48.69	52000.0
2007-07-06 07:30:00	QQQ	ETF	48.66	48.68	48.64	48.64	51726.0
2007-07-06 08:00:00	QQQ	ETF	48.65	48.73	48.65	48.73	548614.0
2007-07-06 08:30:00	QQQ	ETF	48.73	48.76	48.6	48.69	2156952.0
2007-07-06 09:00:00	QQQ	ETF	48.69	48.76	48.68	48.72	600883.0
2007-07-06 09:30:00	QQQ	ETF	48.71	48.74	48.5	48.56	10883948.0
2007-07-06 10:00:00	QQQ	ETF	48.56	48.73	48.54	48.73	8618208.0
2007-07-06 10:30:00	QQQ	ETF	48.73	48.74	48.64	48.68	4260896.0
2007-07-06 11:00:00	QQQ	ETF	48.68	48.8	48.66	48.8	3614991.0
2007-07-06 11:30:00	QQQ	ETF	48.8	48.84	48.76	48.78	4376068.0
2007-07-06 12:00:00	QQQ	ETF	48.78	48.8	48.65	48.66	5896100.0
2007-07-06 12:30:00	QQQ	ETF	48.6699	48.74	48.65	48.74	2509682.0
2007-07-06 13:00:00	QQQ	ETF	48.73	48.77	48.7	48.76	1187332.0
2007-07-06 13:30:00	QQQ	ETF	48.76	48.81	48.73	48.79	3001073.0
2007-07-06 14:00:00	QQQ	ETF	48.7995	48.85	48.76	48.82	3181520.0
2007-07-06 14:30:00	QQQ	ETF	48.82	48.87	48.82	48.87	3789228.0
2007-07-06 15:00:00	QQQ	ETF	48.87	48.9	48.86	48.88	2604981.0
2007-07-06 15:30:00	QQQ	ETF	48.89	48.91	48.84	48.87	5732616.0
2007-07-06 16:00:00	QQQ	ETF	48.87	48.93	48.85	48.93	1476928.0
2007-07-06 16:30:00	QQQ	ETF	48.92	48.94	48.88	48.93	26880.0
2007-07-06 17:00:00	QQQ	ETF	48.93	48.94	48.91	48.94	7850.0
2007-07-06 17:30:00	QQQ	ETF	48.92	48.93	48.91	48.93	18350.0

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

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