PREVIEW / etf_30min / 2007-01-09

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-01-09.parquet
  size:    95 KB
  rows:    3,284

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-01-09 04:30:00	SPY	ETF	141.6	141.6	141.6	141.6	1900.0
2007-01-09 06:00:00	SPY	ETF	141.64	141.64	141.64	141.64	15000.0
2007-01-09 06:30:00	SPY	ETF	141.55	141.59	141.55	141.59	80000.0
2007-01-09 07:00:00	SPY	ETF	141.55	141.55	141.5	141.5	19500.0
2007-01-09 07:30:00	SPY	ETF	141.5	141.5	141.39	141.48	28200.0
2007-01-09 08:00:00	SPY	ETF	141.52	141.55	141.37	141.43	272700.0
2007-01-09 08:30:00	SPY	ETF	141.41	141.49	141.37	141.44	262200.0
2007-01-09 09:00:00	SPY	ETF	141.45	141.45	141.3	141.3	118900.0
2007-01-09 09:30:00	SPY	ETF	141.31	141.45	141.01	141.12	4874200.0
2007-01-09 10:00:00	SPY	ETF	141.13	141.4	140.95	141.32	4448200.0
2007-01-09 10:30:00	SPY	ETF	141.31	141.47	141.19	141.22	3244500.0
2007-01-09 11:00:00	SPY	ETF	141.23	141.33	140.64	140.78	3755100.0
2007-01-09 11:30:00	SPY	ETF	140.79	140.91	140.48	140.55	5224500.0
2007-01-09 12:00:00	SPY	ETF	140.56	140.7	140.4	140.51	5101200.0
2007-01-09 12:30:00	SPY	ETF	140.5	140.73	140.45	140.61	3966800.0
2007-01-09 13:00:00	SPY	ETF	140.61	140.89	140.58	140.76	2401800.0
2007-01-09 13:30:00	SPY	ETF	140.76	141.14	140.75	140.92	5098300.0
2007-01-09 14:00:00	SPY	ETF	140.92	141.25	140.92	140.95	4862000.0
2007-01-09 14:30:00	SPY	ETF	140.95	141.1644	140.79	141.04	5580500.0
2007-01-09 15:00:00	SPY	ETF	141.0488	141.21	140.91	141.18	12094500.0
2007-01-09 15:30:00	SPY	ETF	141.18	141.6	141.04	141.13	6545500.0
2007-01-09 16:00:00	SPY	ETF	141.11	141.18	141.02	141.08	4730000.0
2007-01-09 16:30:00	SPY	ETF	141.08	141.13	141.07	141.13	613700.0
2007-01-09 17:00:00	SPY	ETF	141.11	141.11	141.08	141.08	2000.0
2007-01-09 17:30:00	SPY	ETF	141.06	141.1	141.04	141.04	21900.0
2007-01-09 18:00:00	SPY	ETF	141.08	141.08	141.08	141.08	1000.0
2007-01-09 18:30:00	SPY	ETF	141.05	141.08	141.05	141.08	2000.0
2007-01-09 19:00:00	SPY	ETF	141.08	141.08	141.08	141.08	400.0
2007-01-09 19:30:00	SPY	ETF	141.05	141.05	141.0	141.01	46900.0
2007-01-09 07:00:00	QQQ	ETF	44.06	44.06	44.0	44.0	60500.0
2007-01-09 07:30:00	QQQ	ETF	44.0	44.02	43.97	44.01	174681.0
2007-01-09 08:00:00	QQQ	ETF	44.04	44.05	44.01	44.02	398167.0
2007-01-09 08:30:00	QQQ	ETF	44.04	44.04	44.0	44.03	787821.0
2007-01-09 09:00:00	QQQ	ETF	44.02	44.03	43.98	44.01	398980.0
2007-01-09 09:30:00	QQQ	ETF	44.0	44.1	43.85	43.96	11049900.0
2007-01-09 10:00:00	QQQ	ETF	43.97	44.16	43.88	44.09	10949400.0
2007-01-09 10:30:00	QQQ	ETF	44.09	44.21	44.03	44.11	9764600.0
2007-01-09 11:00:00	QQQ	ETF	44.11	44.16	43.91	43.93	5625800.0
2007-01-09 11:30:00	QQQ	ETF	43.94	44.0	43.84	43.89	9425400.0
2007-01-09 12:00:00	QQQ	ETF	43.88	44.0	43.63	43.76	9481900.0
2007-01-09 12:30:00	QQQ	ETF	43.75	43.89	43.66	43.78	10177000.0
2007-01-09 13:00:00	QQQ	ETF	43.78	43.98	43.75	43.93	4655500.0
2007-01-09 13:30:00	QQQ	ETF	43.94	44.24	43.94	44.09	9586700.0
2007-01-09 14:00:00	QQQ	ETF	44.09	44.2	44.04	44.06	5995500.0
2007-01-09 14:30:00	QQQ	ETF	44.06	44.17	43.99	44.14	6046900.0
2007-01-09 15:00:00	QQQ	ETF	44.13	44.2	44.06	44.19	4176900.0
2007-01-09 15:30:00	QQQ	ETF	44.19	44.29	44.09	44.12	13308200.0
2007-01-09 16:00:00	QQQ	ETF	44.11	44.14	43.9	44.1	2672550.0
2007-01-09 16:30:00	QQQ	ETF	44.1	44.111	44.1	44.1	3628444.0
2007-01-09 17:00:00	QQQ	ETF	44.1	44.11	44.08	44.11	33402.0

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

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