PREVIEW / etf_30min / 2007-10-25

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-10-25.parquet
  size:    137 KB
  rows:    5,051

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-25 04:30:00	SPY	ETF	151.39	151.39	151.39	151.39	2000.0
2007-10-25 05:30:00	SPY	ETF	151.43	151.53	151.43	151.53	61100.0
2007-10-25 06:00:00	SPY	ETF	151.51	151.51	151.51	151.51	2000.0
2007-10-25 06:30:00	SPY	ETF	151.48	151.75	151.48	151.75	62900.0
2007-10-25 07:00:00	SPY	ETF	151.79	152.22	151.79	152.2	1294000.0
2007-10-25 07:30:00	SPY	ETF	152.2	152.2	152.0	152.0	164400.0
2007-10-25 08:00:00	SPY	ETF	152.0	152.05	151.48	151.84	1480200.0
2007-10-25 08:30:00	SPY	ETF	151.83	152.17	151.57	151.87	4211000.0
2007-10-25 09:00:00	SPY	ETF	151.88	151.91	151.64	151.69	1040905.0
2007-10-25 09:30:00	SPY	ETF	151.68	151.73	150.83	150.9	20397424.0
2007-10-25 10:00:00	SPY	ETF	150.91	152.29	150.9	152.05	29963866.0
2007-10-25 10:30:00	SPY	ETF	152.05	152.06	151.61	151.88	12551941.0
2007-10-25 11:00:00	SPY	ETF	151.88	151.99	151.4	151.6	9032500.0
2007-10-25 11:30:00	SPY	ETF	151.61	151.92	151.01	151.05	11856801.0
2007-10-25 12:00:00	SPY	ETF	151.05	151.51	150.8	151.29	12332100.0
2007-10-25 12:30:00	SPY	ETF	151.3	151.3	150.95	151.04	7011300.0
2007-10-25 13:00:00	SPY	ETF	151.04	151.17	150.08	150.31	24288300.0
2007-10-25 13:30:00	SPY	ETF	150.32	150.68	150.0	150.34	9866100.0
2007-10-25 14:00:00	SPY	ETF	150.34	150.88	149.88	150.77	20646000.0
2007-10-25 14:30:00	SPY	ETF	150.78	151.46	150.0	151.37	19188850.0
2007-10-25 15:00:00	SPY	ETF	151.37	151.43	150.95	151.2	13529300.0
2007-10-25 15:30:00	SPY	ETF	151.21	151.75	150.98	151.31	20869500.0
2007-10-25 16:00:00	SPY	ETF	151.35	152.23	150.68	152.2	4714700.0
2007-10-25 16:30:00	SPY	ETF	152.15	152.24	151.84	152.18	3716400.0
2007-10-25 17:00:00	SPY	ETF	152.18	152.18	152.0	152.01	1251800.0
2007-10-25 17:30:00	SPY	ETF	152.0	152.1	151.96	152.1	2619200.0
2007-10-25 18:00:00	SPY	ETF	152.1	152.15	152.05	152.1	76600.0
2007-10-25 18:30:00	SPY	ETF	152.01	152.02	151.83	151.83	25800.0
2007-10-25 19:00:00	SPY	ETF	151.85	151.93	151.83	151.93	6200.0
2007-10-25 19:30:00	SPY	ETF	151.93	152.0	151.93	152.0	15500.0
2007-10-25 05:30:00	QQQ	ETF	53.86	53.9	53.86	53.9	52500.0
2007-10-25 06:30:00	QQQ	ETF	53.99	54.04	53.99	54.04	5800.0
2007-10-25 07:00:00	QQQ	ETF	54.04	54.22	54.04	54.17	940184.0
2007-10-25 07:30:00	QQQ	ETF	54.15	54.2	54.14	54.15	316413.0
2007-10-25 08:00:00	QQQ	ETF	54.14	54.18	53.93	54.16	1847150.0
2007-10-25 08:30:00	QQQ	ETF	54.16	54.19	53.93	54.08	3431639.0
2007-10-25 09:00:00	QQQ	ETF	54.07	54.09	53.87	53.88	1967090.0
2007-10-25 09:30:00	QQQ	ETF	53.88	53.9	53.3	53.32	26019805.0
2007-10-25 10:00:00	QQQ	ETF	53.31	53.98	53.31	53.81	42335441.0
2007-10-25 10:30:00	QQQ	ETF	53.82	53.82	53.57	53.6785	9247196.0
2007-10-25 11:00:00	QQQ	ETF	53.6795	53.72	53.42	53.53	10113175.0
2007-10-25 11:30:00	QQQ	ETF	53.53	53.65	53.0	53.0	13043476.0
2007-10-25 12:00:00	QQQ	ETF	53.0	53.31	52.96	53.3	18523746.0
2007-10-25 12:30:00	QQQ	ETF	53.3	53.31	53.09	53.15	9214792.0
2007-10-25 13:00:00	QQQ	ETF	53.14	53.7978	52.82	52.947	16400464.0
2007-10-25 13:30:00	QQQ	ETF	52.96	53.1	52.8914	52.95	8310871.0
2007-10-25 14:00:00	QQQ	ETF	52.948	53.15	52.75	53.07	16087550.0
2007-10-25 14:30:00	QQQ	ETF	53.07	53.3	52.98	53.27	14451073.0
2007-10-25 15:00:00	QQQ	ETF	53.27	53.33	53.09	53.15	11601307.0
2007-10-25 15:30:00	QQQ	ETF	53.15	53.38	53.04	53.1	21349306.0

> showing 50 of 5,051 rows — these rows as CSV

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