PREVIEW / etf_30min / 2007-07-09

all etf 30-min files

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

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-09 06:00:00	SPY	ETF	153.18	153.18	153.18	153.18	15000.0
2007-07-09 06:30:00	SPY	ETF	153.19	153.23	153.19	153.23	13500.0
2007-07-09 07:00:00	SPY	ETF	153.18	153.32	153.14	153.31	41000.0
2007-07-09 07:30:00	SPY	ETF	153.3	153.33	153.23	153.26	7400.0
2007-07-09 08:00:00	SPY	ETF	153.19	153.33	152.95	153.21	172100.0
2007-07-09 08:30:00	SPY	ETF	153.21	153.23	153.07	153.12	214900.0
2007-07-09 09:00:00	SPY	ETF	153.1	153.21	153.08	153.13	386214.0
2007-07-09 09:30:00	SPY	ETF	153.16	153.33	153.02	153.1	12173994.0
2007-07-09 10:00:00	SPY	ETF	153.11	153.28	153.05	153.12	6042435.0
2007-07-09 10:30:00	SPY	ETF	153.11	153.14	152.62	152.64	9162633.0
2007-07-09 11:00:00	SPY	ETF	152.64	153.0	152.63	152.95	4215520.0
2007-07-09 11:30:00	SPY	ETF	152.95	152.98	152.84	152.92	2786900.0
2007-07-09 12:00:00	SPY	ETF	152.93	152.96	152.81	152.96	1871928.0
2007-07-09 12:30:00	SPY	ETF	152.96	153.12	152.9	153.0601	4392755.0
2007-07-09 13:00:00	SPY	ETF	153.06	153.13	152.92	153.1	2921541.0
2007-07-09 13:30:00	SPY	ETF	153.1	153.17	153.02	153.13	1907300.0
2007-07-09 14:00:00	SPY	ETF	153.14	153.16	152.86	152.91	4315152.0
2007-07-09 14:30:00	SPY	ETF	152.9	153.31	152.89	153.27	5913035.0
2007-07-09 15:00:00	SPY	ETF	153.28	153.36	153.17	153.23	5487802.0
2007-07-09 15:30:00	SPY	ETF	153.23	153.25	153.07	153.09	6362850.0
2007-07-09 16:00:00	SPY	ETF	153.1	153.1881	152.97	153.06	1214900.0
2007-07-09 16:30:00	SPY	ETF	153.06	153.08	153.02	153.07	143700.0
2007-07-09 17:00:00	SPY	ETF	153.09	153.12	153.06	153.07	229600.0
2007-07-09 17:30:00	SPY	ETF	153.0	153.02	152.96	153.0	82000.0
2007-07-09 18:00:00	SPY	ETF	153.0	153.07	152.96	152.96	666900.0
2007-07-09 18:30:00	SPY	ETF	152.99	153.0	152.99	153.0	3900.0
2007-07-09 19:00:00	SPY	ETF	152.99	153.0	152.96	152.96	4100.0
2007-07-09 19:30:00	SPY	ETF	153.02	153.06	153.02	153.06	400.0
2007-07-09 06:00:00	QQQ	ETF	48.95	48.95	48.95	48.95	3000.0
2007-07-09 07:00:00	QQQ	ETF	48.94	48.99	48.94	48.98	116549.0
2007-07-09 07:30:00	QQQ	ETF	48.96	48.99	48.96	48.96	6165.0
2007-07-09 08:00:00	QQQ	ETF	48.95	48.99	48.93	48.96	271866.0
2007-07-09 08:30:00	QQQ	ETF	48.96	48.97	48.89	48.9	399405.0
2007-07-09 09:00:00	QQQ	ETF	48.9	48.91	48.87	48.89	417768.0
2007-07-09 09:30:00	QQQ	ETF	48.9	48.95	48.81	48.845	12432556.0
2007-07-09 10:00:00	QQQ	ETF	48.8499	48.97	48.84	48.92	5904984.0
2007-07-09 10:30:00	QQQ	ETF	48.915	48.92	48.72	48.76	9737758.0
2007-07-09 11:00:00	QQQ	ETF	48.75	48.89	48.75	48.87	3138387.0
2007-07-09 11:30:00	QQQ	ETF	48.8715	48.9	48.85	48.8815	1898776.0
2007-07-09 12:00:00	QQQ	ETF	48.88	48.9	48.84	48.88	2086333.0
2007-07-09 12:30:00	QQQ	ETF	48.885	48.93	48.85	48.9	3358291.0
2007-07-09 13:00:00	QQQ	ETF	48.902	48.93	48.87	48.93	2464804.0
2007-07-09 13:30:00	QQQ	ETF	48.93	48.95	48.89	48.94	1371289.0
2007-07-09 14:00:00	QQQ	ETF	48.93	48.94	48.83	48.845	2958722.0
2007-07-09 14:30:00	QQQ	ETF	48.85	48.97	48.84	48.96	4092694.0
2007-07-09 15:00:00	QQQ	ETF	48.95	48.98	48.94	48.955	2588031.0
2007-07-09 15:30:00	QQQ	ETF	48.955	48.96	48.9	48.91	6070691.0
2007-07-09 16:00:00	QQQ	ETF	48.91	48.94	48.88	48.91	3315061.0
2007-07-09 16:30:00	QQQ	ETF	48.91	48.94	48.91	48.93	381900.0
2007-07-09 17:00:00	QQQ	ETF	48.94	48.95	48.93	48.94	102975.0

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

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