PREVIEW / etf_30min / 2008-12-15

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-12-15.parquet
  size:    181 KB
  rows:    6,484

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
2008-12-15 04:00:00	SPY	ETF	88.45	88.5	88.32	88.44	5100.0
2008-12-15 04:30:00	SPY	ETF	88.46	88.46	88.27	88.33	1800.0
2008-12-15 05:00:00	SPY	ETF	88.45	88.8	88.45	88.8	2500.0
2008-12-15 05:30:00	SPY	ETF	88.72	88.86	88.72	88.86	3200.0
2008-12-15 06:00:00	SPY	ETF	89.03	89.18	89.03	89.18	6469.0
2008-12-15 06:30:00	SPY	ETF	89.23	89.29	89.08	89.26	14600.0
2008-12-15 07:00:00	SPY	ETF	89.17	89.17	88.7	88.87	184188.0
2008-12-15 07:30:00	SPY	ETF	88.88	88.97	88.56	88.74	68650.0
2008-12-15 08:00:00	SPY	ETF	88.75	88.85	88.65	88.65	353742.0
2008-12-15 08:30:00	SPY	ETF	88.7	89.16	88.7	88.84	1407280.0
2008-12-15 09:00:00	SPY	ETF	88.83	89.726	88.76	89.01	3033115.0
2008-12-15 09:30:00	SPY	ETF	89.02	89.15	87.9	87.94	23344866.0
2008-12-15 10:00:00	SPY	ETF	87.94	88.0	87.33	87.58	20615558.0
2008-12-15 10:30:00	SPY	ETF	87.59	87.88	87.07	87.15	16668776.0
2008-12-15 11:00:00	SPY	ETF	87.15	87.6	86.96	87.42	14891906.0
2008-12-15 11:30:00	SPY	ETF	87.42	87.76	87.16	87.57	10683889.0
2008-12-15 12:00:00	SPY	ETF	87.56	88.0	87.33	87.91	11132511.0
2008-12-15 12:30:00	SPY	ETF	87.91	87.97	87.2	87.34	8946316.0
2008-12-15 13:00:00	SPY	ETF	87.33	87.42	86.71	87.27	19612569.0
2008-12-15 13:30:00	SPY	ETF	87.27	87.59	87.18	87.29	12793713.0
2008-12-15 14:00:00	SPY	ETF	87.29	87.7	87.01	87.05	12922100.0
2008-12-15 14:30:00	SPY	ETF	87.05	87.43	86.75	86.7699	14036703.0
2008-12-15 15:00:00	SPY	ETF	86.76	87.02	86.29	86.59	19209493.0
2008-12-15 15:30:00	SPY	ETF	86.58	88.0	86.33	87.5	47470894.0
2008-12-15 16:00:00	SPY	ETF	87.47	88.0	86.3	87.89	8815076.0
2008-12-15 16:30:00	SPY	ETF	87.88	87.94	87.85	87.92	3275859.0
2008-12-15 17:00:00	SPY	ETF	87.92	88.02	87.81	87.84	1070487.0
2008-12-15 17:30:00	SPY	ETF	87.89	87.89	87.84	87.86	12912.0
2008-12-15 18:00:00	SPY	ETF	87.84	87.89	87.79	87.8	46892.0
2008-12-15 18:30:00	SPY	ETF	87.84	87.88	87.74	87.79	22344.0
2008-12-15 19:00:00	SPY	ETF	87.8	87.83	87.67	87.69	11371.0
2008-12-15 19:30:00	SPY	ETF	87.71	87.79	87.5	87.64	118272.0
2008-12-15 04:30:00	QQQ	ETF	29.57	29.57	29.57	29.57	540.0
2008-12-15 05:30:00	QQQ	ETF	29.87	29.87	29.87	29.87	950.0
2008-12-15 06:00:00	QQQ	ETF	29.91	29.91	29.91	29.91	200.0
2008-12-15 06:30:00	QQQ	ETF	30.0	30.0	30.0	30.0	813.0
2008-12-15 07:00:00	QQQ	ETF	30.0	30.0	29.87	29.93	51378.0
2008-12-15 07:30:00	QQQ	ETF	29.95	29.99	29.88	29.88	23063.0
2008-12-15 08:00:00	QQQ	ETF	29.88	29.92	29.69	29.89	206993.0
2008-12-15 08:30:00	QQQ	ETF	29.9	29.95	29.81	29.86	1684353.0
2008-12-15 09:00:00	QQQ	ETF	29.86	29.93	29.72	29.72	739456.0
2008-12-15 09:30:00	QQQ	ETF	29.72	29.76	29.24	29.25	12565359.0
2008-12-15 10:00:00	QQQ	ETF	29.24	29.55	28.98	29.07	10989626.0
2008-12-15 10:30:00	QQQ	ETF	29.07	29.14	28.84	28.8701	9108950.0
2008-12-15 11:00:00	QQQ	ETF	28.87	29.07	28.81	29.01	6423218.0
2008-12-15 11:30:00	QQQ	ETF	29.0	29.16	28.97	29.08	5416159.0
2008-12-15 12:00:00	QQQ	ETF	29.08	29.2	29.02	29.15	4175448.0
2008-12-15 12:30:00	QQQ	ETF	29.15	29.18	28.97	29.03	3116868.0
2008-12-15 13:00:00	QQQ	ETF	29.03	29.04	28.85	28.98	5490872.0
2008-12-15 13:30:00	QQQ	ETF	28.98	29.06	28.95	28.99	4233388.0

> showing 50 of 6,484 rows — these rows as CSV

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