PREVIEW / etf_30min / 2008-11-17

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-11-17.parquet
  size:    177 KB
  rows:    6,304

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-11-17 04:00:00	SPY	ETF	87.7	87.81	87.7	87.81	9200.0
2008-11-17 04:30:00	SPY	ETF	87.65	87.65	86.99	86.99	4800.0
2008-11-17 05:00:00	SPY	ETF	86.89	86.98	86.63	86.69	25900.0
2008-11-17 05:30:00	SPY	ETF	86.76	86.76	86.25	86.25	2700.0
2008-11-17 06:00:00	SPY	ETF	86.3	86.3	85.86	85.86	21490.0
2008-11-17 06:30:00	SPY	ETF	85.88	86.08	85.79	86.06	68981.0
2008-11-17 07:00:00	SPY	ETF	86.09	86.1	85.7	85.76	443541.0
2008-11-17 07:30:00	SPY	ETF	85.71	86.0	85.47	85.74	1712611.0
2008-11-17 08:00:00	SPY	ETF	85.72	87.3	85.4	85.9	1198206.0
2008-11-17 08:30:00	SPY	ETF	85.9	85.93	85.47	85.58	2656648.0
2008-11-17 09:00:00	SPY	ETF	85.58	86.62	85.58	86.39	2790614.0
2008-11-17 09:30:00	SPY	ETF	86.38	87.02	85.85	86.791	48441221.0
2008-11-17 10:00:00	SPY	ETF	86.79	86.84	85.16	85.6	33458518.0
2008-11-17 10:30:00	SPY	ETF	85.6	86.07	85.34	85.4	27597556.0
2008-11-17 11:00:00	SPY	ETF	85.4	86.59	85.36	85.94	23942534.0
2008-11-17 11:30:00	SPY	ETF	85.95	87.62	85.77	87.4	22612324.0
2008-11-17 12:00:00	SPY	ETF	87.39	88.18	87.11	88.07	29096646.0
2008-11-17 12:30:00	SPY	ETF	88.07	88.56	87.44	87.71	29632070.0
2008-11-17 13:00:00	SPY	ETF	87.71	87.9	87.0	87.41	21723072.0
2008-11-17 13:30:00	SPY	ETF	87.41	87.57	86.52	87.29	18849242.0
2008-11-17 14:00:00	SPY	ETF	87.28	87.8	86.6	86.77	23667657.0
2008-11-17 14:30:00	SPY	ETF	86.77	87.76	86.49	86.7801	30450838.0
2008-11-17 15:00:00	SPY	ETF	86.79	87.65	86.49	87.07	25663287.0
2008-11-17 15:30:00	SPY	ETF	87.08	87.4	85.2	85.39	51380237.0
2008-11-17 16:00:00	SPY	ETF	85.38	86.8831	85.3	85.54	14501024.0
2008-11-17 16:30:00	SPY	ETF	85.51	87.6224	85.2	85.2	3488247.0
2008-11-17 17:00:00	SPY	ETF	85.2	87.62	85.19	85.43	483758.0
2008-11-17 17:30:00	SPY	ETF	85.36	85.4	85.33	85.34	45000.0
2008-11-17 18:00:00	SPY	ETF	85.34	85.34	85.13	85.13	51114.0
2008-11-17 18:30:00	SPY	ETF	85.15	85.3	85.1	85.3	109903.0
2008-11-17 19:00:00	SPY	ETF	85.32	85.46	85.28	85.4	41848.0
2008-11-17 19:30:00	SPY	ETF	85.39	85.39	85.19	85.29	22778.0
2008-11-17 04:00:00	QQQ	ETF	28.79	28.84	28.78	28.84	3200.0
2008-11-17 04:30:00	QQQ	ETF	28.86	28.86	28.66	28.66	1900.0
2008-11-17 05:00:00	QQQ	ETF	28.54	28.54	28.54	28.54	200.0
2008-11-17 05:30:00	QQQ	ETF	28.48	28.48	28.48	28.48	100.0
2008-11-17 06:00:00	QQQ	ETF	28.36	28.36	28.36	28.36	200.0
2008-11-17 06:30:00	QQQ	ETF	28.18	28.3	28.18	28.27	75500.0
2008-11-17 07:00:00	QQQ	ETF	28.26	28.33	28.2	28.27	139746.0
2008-11-17 07:30:00	QQQ	ETF	28.22	28.39	28.16	28.36	294202.0
2008-11-17 08:00:00	QQQ	ETF	28.34	28.75	28.27	28.28	775853.0
2008-11-17 08:30:00	QQQ	ETF	28.28	28.31	28.2	28.22	646527.0
2008-11-17 09:00:00	QQQ	ETF	28.22	28.51	28.22	28.49	1109526.0
2008-11-17 09:30:00	QQQ	ETF	28.49	28.83	28.37	28.75	27926325.0
2008-11-17 10:00:00	QQQ	ETF	28.76	28.78	28.26	28.42	17237836.0
2008-11-17 10:30:00	QQQ	ETF	28.42	28.55	28.35	28.37	11542506.0
2008-11-17 11:00:00	QQQ	ETF	28.36	28.73	28.36	28.52	9675577.0
2008-11-17 11:30:00	QQQ	ETF	28.53	28.98	28.46	28.9	10515308.0
2008-11-17 12:00:00	QQQ	ETF	28.8999	29.09	28.83	29.05	12168503.0
2008-11-17 12:30:00	QQQ	ETF	29.05	29.23	28.86	29.07	12406418.0

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

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