PREVIEW / etf_30min / 2007-02-20

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-02-20.parquet
  size:    101 KB
  rows:    3,551

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-02-20 04:00:00	SPY	ETF	145.73	145.73	145.73	145.73	200.0
2007-02-20 06:00:00	SPY	ETF	145.7	145.7	145.7	145.7	10000.0
2007-02-20 06:30:00	SPY	ETF	145.57	145.57	145.57	145.57	100.0
2007-02-20 07:00:00	SPY	ETF	145.58	145.67	145.56	145.64	16300.0
2007-02-20 07:30:00	SPY	ETF	145.65	145.65	145.63	145.64	99000.0
2007-02-20 08:00:00	SPY	ETF	145.64	145.65	145.58	145.63	429000.0
2007-02-20 08:30:00	SPY	ETF	145.65	145.65	145.51	145.53	185500.0
2007-02-20 09:00:00	SPY	ETF	145.53	145.56	145.47	145.5	216700.0
2007-02-20 09:30:00	SPY	ETF	145.56	145.62	145.16	145.24	7692500.0
2007-02-20 10:00:00	SPY	ETF	145.25	145.38	144.06	145.3201	4801900.0
2007-02-20 10:30:00	SPY	ETF	145.33	145.5	145.24	145.41	3460600.0
2007-02-20 11:00:00	SPY	ETF	145.42	146.01	145.41	145.84	7464300.0
2007-02-20 11:30:00	SPY	ETF	145.85	146.02	145.8	145.96	5127700.0
2007-02-20 12:00:00	SPY	ETF	145.96	146.07	145.93	146.0	2395800.0
2007-02-20 12:30:00	SPY	ETF	146.0	146.01	145.83	145.94	3996600.0
2007-02-20 13:00:00	SPY	ETF	145.93	146.01	145.79	145.8	1839200.0
2007-02-20 13:30:00	SPY	ETF	145.8	146.01	145.79	145.989	3235000.0
2007-02-20 14:00:00	SPY	ETF	145.98	146.05	145.9	145.98	1566500.0
2007-02-20 14:30:00	SPY	ETF	145.98	146.12	145.94	146.1	1963700.0
2007-02-20 15:00:00	SPY	ETF	146.11	146.2	146.07	146.14	3683500.0
2007-02-20 15:30:00	SPY	ETF	146.15	146.2	146.05	146.1	3606300.0
2007-02-20 16:00:00	SPY	ETF	146.1	146.11	145.97	146.01	915600.0
2007-02-20 16:30:00	SPY	ETF	146.0	146.01	145.96	146.0	253800.0
2007-02-20 17:00:00	SPY	ETF	146.0	146.04	145.95	145.95	506600.0
2007-02-20 17:30:00	SPY	ETF	146.0	146.03	146.0	146.03	2300.0
2007-02-20 18:00:00	SPY	ETF	145.96	145.99	145.95	145.99	12000.0
2007-02-20 18:30:00	SPY	ETF	145.98	145.98	145.98	145.98	100.0
2007-02-20 19:00:00	SPY	ETF	145.95	145.95	145.95	145.95	500.0
2007-02-20 19:30:00	SPY	ETF	145.99	145.99	145.99	145.99	100.0
2007-02-20 04:00:00	QQQ	ETF	44.76	44.76	44.76	44.76	100.0
2007-02-20 06:30:00	QQQ	ETF	44.68	44.68	44.68	44.68	900.0
2007-02-20 07:00:00	QQQ	ETF	44.69	44.7	44.68	44.68	185200.0
2007-02-20 07:30:00	QQQ	ETF	44.69	44.73	44.68	44.73	190400.0
2007-02-20 08:00:00	QQQ	ETF	44.72	44.72	44.69	44.71	853552.0
2007-02-20 08:30:00	QQQ	ETF	44.7	44.72	44.69	44.7	330318.0
2007-02-20 09:00:00	QQQ	ETF	44.69	44.69	44.63	44.65	603965.0
2007-02-20 09:30:00	QQQ	ETF	44.65	44.71	44.53	44.61	13448800.0
2007-02-20 10:00:00	QQQ	ETF	44.6	44.62	44.43	44.62	10376000.0
2007-02-20 10:30:00	QQQ	ETF	44.61	44.72	44.56	44.68	9672700.0
2007-02-20 11:00:00	QQQ	ETF	44.68	44.95	44.68	44.95	10385600.0
2007-02-20 11:30:00	QQQ	ETF	44.95	45.05	44.94	44.99	6491500.0
2007-02-20 12:00:00	QQQ	ETF	44.99	45.09	44.97	45.04	3953900.0
2007-02-20 12:30:00	QQQ	ETF	45.03	45.04	44.95	44.98	3027800.0
2007-02-20 13:00:00	QQQ	ETF	44.99	45.05	44.91	44.93	3233500.0
2007-02-20 13:30:00	QQQ	ETF	44.93	45.03	44.92	45.02	2970900.0
2007-02-20 14:00:00	QQQ	ETF	45.02	45.07	44.97	45.03	2973500.0
2007-02-20 14:30:00	QQQ	ETF	45.02	45.11	45.02	45.09	3052800.0
2007-02-20 15:00:00	QQQ	ETF	45.08	45.12	45.06	45.09	2571500.0
2007-02-20 15:30:00	QQQ	ETF	45.09	45.09	45.03	45.05	6043800.0
2007-02-20 16:00:00	QQQ	ETF	45.05	45.09	45.01	45.07	2694501.0

> showing 50 of 3,551 rows — these rows as CSV

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