PREVIEW / etf_30min / 2008-12-23

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-12-23.parquet
  size:    203 KB
  rows:    6,658

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-23 04:00:00	SPY	ETF	87.38	87.58	87.38	87.58	5000.0
2008-12-23 04:30:00	SPY	ETF	87.53	87.81	87.53	87.79	1960.0
2008-12-23 05:00:00	SPY	ETF	87.75	87.8	87.65	87.79	5969.0
2008-12-23 05:30:00	SPY	ETF	87.72	87.95	87.68	87.95	1257.0
2008-12-23 06:00:00	SPY	ETF	87.69	87.72	87.53	87.53	4360.0
2008-12-23 06:30:00	SPY	ETF	87.49	87.49	87.32	87.42	6670.0
2008-12-23 07:00:00	SPY	ETF	87.5	87.65	87.13	87.59	117594.0
2008-12-23 07:30:00	SPY	ETF	87.65	87.8	87.25	87.25	250698.0
2008-12-23 08:00:00	SPY	ETF	87.28	87.49	87.22	87.39	217989.0
2008-12-23 08:30:00	SPY	ETF	87.35	87.75	87.0	87.5	1092281.0
2008-12-23 09:00:00	SPY	ETF	87.49	87.8	87.48	87.52	1553544.0
2008-12-23 09:30:00	SPY	ETF	87.52	87.79	87.195	87.64	19927248.0
2008-12-23 10:00:00	SPY	ETF	87.64	87.72	87.08	87.61	23540801.0
2008-12-23 10:30:00	SPY	ETF	87.62	87.93	87.42	87.42	19094546.0
2008-12-23 11:00:00	SPY	ETF	87.42	87.57	86.81	86.85	14349330.0
2008-12-23 11:30:00	SPY	ETF	86.85	87.16	86.53	86.55	12340492.0
2008-12-23 12:00:00	SPY	ETF	86.56	86.61	86.28	86.51	11676665.0
2008-12-23 12:30:00	SPY	ETF	86.51	86.63	86.17	86.53	13915929.0
2008-12-23 13:00:00	SPY	ETF	86.53	86.62	86.33	86.53	8353170.0
2008-12-23 13:30:00	SPY	ETF	86.53	86.89	86.35	86.82	8817523.0
2008-12-23 14:00:00	SPY	ETF	86.83	86.9983	86.5	86.76	12710851.0
2008-12-23 14:30:00	SPY	ETF	86.75	87.49	85.91	86.11	19401047.0
2008-12-23 15:00:00	SPY	ETF	86.11	86.53	85.8	86.31	16681643.0
2008-12-23 15:30:00	SPY	ETF	86.32	86.59	86.0	86.17	21993553.0
2008-12-23 16:00:00	SPY	ETF	86.16	86.4	85.75	86.04	5223929.0
2008-12-23 16:30:00	SPY	ETF	86.09	86.9983	86.08	86.15	8896689.0
2008-12-23 17:00:00	SPY	ETF	86.12	86.21	86.09	86.09	47848.0
2008-12-23 17:30:00	SPY	ETF	86.12	86.19	86.11	86.13	7807.0
2008-12-23 18:00:00	SPY	ETF	86.12	86.22	86.04	86.18	53207.0
2008-12-23 18:30:00	SPY	ETF	86.13	86.3	86.07	86.3	27895.0
2008-12-23 19:00:00	SPY	ETF	86.26	86.39	86.25	86.39	25077.0
2008-12-23 19:30:00	SPY	ETF	86.3	86.31	86.16	86.21	15559.0
2008-12-23 05:00:00	QQQ	ETF	29.37	29.44	29.37	29.44	600.0
2008-12-23 05:30:00	QQQ	ETF	29.42	29.42	29.42	29.42	470.0
2008-12-23 07:00:00	QQQ	ETF	29.3	29.38	29.3	29.37	25241.0
2008-12-23 07:30:00	QQQ	ETF	29.41	29.47	29.27	29.31	31655.0
2008-12-23 08:00:00	QQQ	ETF	29.29	29.33	29.24	29.29	302428.0
2008-12-23 08:30:00	QQQ	ETF	29.31	29.38	29.2	29.32	471144.0
2008-12-23 09:00:00	QQQ	ETF	29.31	29.4	29.27	29.28	913161.0
2008-12-23 09:30:00	QQQ	ETF	29.28	29.55	29.2579	29.53	6447852.0
2008-12-23 10:00:00	QQQ	ETF	29.52	29.57	29.32	29.4699	8511857.0
2008-12-23 10:30:00	QQQ	ETF	29.46	29.62	29.45	29.45	8495639.0
2008-12-23 11:00:00	QQQ	ETF	29.45	29.52	29.29	29.319	4070727.0
2008-12-23 11:30:00	QQQ	ETF	29.32	29.41	29.14	29.16	4471806.0
2008-12-23 12:00:00	QQQ	ETF	29.16	29.19	29.03	29.1099	4891158.0
2008-12-23 12:30:00	QQQ	ETF	29.1	29.15	28.99	29.1204	3354357.0
2008-12-23 13:00:00	QQQ	ETF	29.12	29.15	29.06	29.11	2756477.0
2008-12-23 13:30:00	QQQ	ETF	29.12	29.2	29.05	29.18	2146678.0
2008-12-23 14:00:00	QQQ	ETF	29.18	29.19	29.1	29.11	2185214.0
2008-12-23 14:30:00	QQQ	ETF	29.1195	29.15	28.89	28.99	5476803.0

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

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