PREVIEW / etf_30min / 2007-09-10

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-09-10.parquet
  size:    127 KB
  rows:    4,616

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-09-10 05:00:00	SPY	ETF	146.42	146.42	146.42	146.42	300.0
2007-09-10 06:00:00	SPY	ETF	146.04	146.04	146.04	146.04	300.0
2007-09-10 06:30:00	SPY	ETF	146.03	146.22	146.03	146.22	85700.0
2007-09-10 07:00:00	SPY	ETF	146.33	146.44	146.09	146.13	126100.0
2007-09-10 07:30:00	SPY	ETF	146.15	146.28	145.87	145.9	706000.0
2007-09-10 08:00:00	SPY	ETF	145.93	146.3	145.9	146.19	1333000.0
2007-09-10 08:30:00	SPY	ETF	146.17	146.43	146.15	146.4	1858800.0
2007-09-10 09:00:00	SPY	ETF	146.4	146.8	146.07	146.5	13090900.0
2007-09-10 09:30:00	SPY	ETF	146.52	146.72	145.96	145.97	11858772.0
2007-09-10 10:00:00	SPY	ETF	145.97	146.11	145.49	145.49	14340300.0
2007-09-10 10:30:00	SPY	ETF	145.5	145.59	144.76	145.07	22435500.0
2007-09-10 11:00:00	SPY	ETF	145.07	145.17	144.41	144.57	16271100.0
2007-09-10 11:30:00	SPY	ETF	144.56	145.02	144.33	144.85	14842300.0
2007-09-10 12:00:00	SPY	ETF	144.85	145.15	144.71	144.99	9588000.0
2007-09-10 12:30:00	SPY	ETF	144.99	145.1	144.72	144.96	6692700.0
2007-09-10 13:00:00	SPY	ETF	144.96	145.368	144.81	145.33	9816300.0
2007-09-10 13:30:00	SPY	ETF	145.33	145.54	145.02	145.08	9391800.0
2007-09-10 14:00:00	SPY	ETF	145.08	145.66	144.88	145.64	7854500.0
2007-09-10 14:30:00	SPY	ETF	145.64	145.88	145.49	145.78	9050100.0
2007-09-10 15:00:00	SPY	ETF	145.78	146.65	145.56	146.29	17235600.0
2007-09-10 15:30:00	SPY	ETF	146.29	146.5	145.5	145.51	15873300.0
2007-09-10 16:00:00	SPY	ETF	145.5	146.34	145.5	145.75	3938400.0
2007-09-10 16:30:00	SPY	ETF	145.75	145.76	145.65	145.69	180400.0
2007-09-10 17:00:00	SPY	ETF	145.69	145.69	145.61	145.62	271300.0
2007-09-10 17:30:00	SPY	ETF	145.62	145.67	145.56	145.6	7900.0
2007-09-10 18:00:00	SPY	ETF	145.6	145.68	145.6	145.68	29900.0
2007-09-10 18:30:00	SPY	ETF	145.68	145.68	145.6	145.6	7000.0
2007-09-10 19:00:00	SPY	ETF	145.65	145.67	145.64	145.67	3200.0
2007-09-10 19:30:00	SPY	ETF	145.67	145.68	145.63	145.68	10600.0
2007-09-10 07:00:00	QQQ	ETF	48.41	48.44	48.36	48.37	37100.0
2007-09-10 07:30:00	QQQ	ETF	48.37	48.41	48.29	48.29	332452.0
2007-09-10 08:00:00	QQQ	ETF	48.32	48.5	48.1	48.37	1842536.0
2007-09-10 08:30:00	QQQ	ETF	48.37	48.52	48.36	48.51	2634198.0
2007-09-10 09:00:00	QQQ	ETF	48.52	48.77	48.52	48.62	6928721.0
2007-09-10 09:30:00	QQQ	ETF	48.621	48.75	48.34	48.35	11080749.0
2007-09-10 10:00:00	QQQ	ETF	48.35	48.37	48.15	48.16	6477039.0
2007-09-10 10:30:00	QQQ	ETF	48.16	48.2	47.96	48.06	10006930.0
2007-09-10 11:00:00	QQQ	ETF	48.06	48.12	47.86	47.92	9033145.0
2007-09-10 11:30:00	QQQ	ETF	47.92	48.08	47.81	48.08	6952853.0
2007-09-10 12:00:00	QQQ	ETF	48.08	48.18	47.98	48.119	4623803.0
2007-09-10 12:30:00	QQQ	ETF	48.12	48.15	48.0	48.07	2484658.0
2007-09-10 13:00:00	QQQ	ETF	48.06	48.23	48.01	48.22	4120853.0
2007-09-10 13:30:00	QQQ	ETF	48.21	48.3	48.1015	48.14	5921986.0
2007-09-10 14:00:00	QQQ	ETF	48.147	48.3	48.06	48.29	4156113.0
2007-09-10 14:30:00	QQQ	ETF	48.29	48.39	48.25	48.3492	6624440.0
2007-09-10 15:00:00	QQQ	ETF	48.34	48.63	48.28	48.5	8098925.0
2007-09-10 15:30:00	QQQ	ETF	48.49	48.54	48.18	48.21	13916298.0
2007-09-10 16:00:00	QQQ	ETF	48.2	48.6	48.2	48.28	2488327.0
2007-09-10 16:30:00	QQQ	ETF	48.28	48.33	48.28	48.31	280816.0
2007-09-10 17:00:00	QQQ	ETF	48.31	48.33	48.29	48.33	1664.0

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

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