PREVIEW / etf_30min / 2010-02-01

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-02-01.parquet
  size:    249 KB
  rows:    8,285

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
2010-02-01 04:00:00	SPY	ETF	107.9	108.16	107.9	108.16	3600.0
2010-02-01 04:30:00	SPY	ETF	108.09	108.09	108.03	108.03	800.0
2010-02-01 05:00:00	SPY	ETF	108.09	108.09	107.98	108.03	14971.0
2010-02-01 05:30:00	SPY	ETF	107.98	108.04	107.95	107.95	1700.0
2010-02-01 06:00:00	SPY	ETF	107.93	108.08	107.92	108.08	6289.0
2010-02-01 06:30:00	SPY	ETF	107.92	107.98	107.9	107.95	13300.0
2010-02-01 07:00:00	SPY	ETF	107.91	108.01	107.86	107.97	277842.0
2010-02-01 07:30:00	SPY	ETF	107.98	108.15	107.98	108.15	529538.0
2010-02-01 08:00:00	SPY	ETF	108.15	108.25	107.88	108.15	2629488.0
2010-02-01 08:30:00	SPY	ETF	108.14	108.23	108.01	108.04	1202794.0
2010-02-01 09:00:00	SPY	ETF	108.05	108.24	107.37	108.15	1246719.0
2010-02-01 09:30:00	SPY	ETF	108.15	108.5	108.08	108.33	22480921.0
2010-02-01 10:00:00	SPY	ETF	108.33	108.79	108.12	108.61	23927507.0
2010-02-01 10:30:00	SPY	ETF	108.61	108.81	108.3	108.31	16295005.0
2010-02-01 11:00:00	SPY	ETF	108.375	108.87	108.24	108.79	15644644.0
2010-02-01 11:30:00	SPY	ETF	108.78	108.79	108.25	108.45	8216340.0
2010-02-01 12:00:00	SPY	ETF	108.44	108.595	108.36	108.53	8452672.0
2010-02-01 12:30:00	SPY	ETF	108.54	108.8	108.47	108.7	9031316.0
2010-02-01 13:00:00	SPY	ETF	108.7	108.93	108.59	108.82	7225751.0
2010-02-01 13:30:00	SPY	ETF	108.82	108.86	108.63	108.75	6480237.0
2010-02-01 14:00:00	SPY	ETF	108.75	108.84	108.45	108.7	8716333.0
2010-02-01 14:30:00	SPY	ETF	108.7	108.91	108.68	108.75	9793469.0
2010-02-01 15:00:00	SPY	ETF	108.75	108.91	108.57	108.82	12783420.0
2010-02-01 15:30:00	SPY	ETF	108.81	109.07	108.69	109.0	18197094.0
2010-02-01 16:00:00	SPY	ETF	109.01	109.17	108.16	109.07	8765995.0
2010-02-01 16:30:00	SPY	ETF	109.06	109.1	107.5008	109.08	3241366.0
2010-02-01 17:00:00	SPY	ETF	109.07	109.08	109.04	109.05	39390.0
2010-02-01 17:30:00	SPY	ETF	109.05	109.08	109.03	109.08	26294.0
2010-02-01 18:00:00	SPY	ETF	109.07	109.08	109.01	109.05	47607.0
2010-02-01 18:30:00	SPY	ETF	109.05	109.13	109.05	109.13	152056.0
2010-02-01 19:00:00	SPY	ETF	109.1	109.13	109.06	109.1	92480.0
2010-02-01 19:30:00	SPY	ETF	109.09	109.2	109.09	109.17	32357.0
2010-02-01 04:00:00	QQQ	ETF	43.02	43.07	43.02	43.07	550.0
2010-02-01 07:00:00	QQQ	ETF	42.91	42.96	42.91	42.94	12182.0
2010-02-01 07:30:00	QQQ	ETF	42.94	43.0	42.94	42.99	159404.0
2010-02-01 08:00:00	QQQ	ETF	42.99	43.04	42.8	42.97	432893.0
2010-02-01 08:30:00	QQQ	ETF	42.97	43.04	42.9	42.9	720450.0
2010-02-01 09:00:00	QQQ	ETF	42.91	43.0	42.79	42.91	778245.0
2010-02-01 09:30:00	QQQ	ETF	42.91	43.18	42.89	43.09	17098632.0
2010-02-01 10:00:00	QQQ	ETF	43.1	43.21	42.93	43.1095	19497982.0
2010-02-01 10:30:00	QQQ	ETF	43.11	43.21	42.9	42.92	10822358.0
2010-02-01 11:00:00	QQQ	ETF	42.92	43.18	42.88	43.13	9261195.0
2010-02-01 11:30:00	QQQ	ETF	43.13	43.15	42.9301	42.94	5511557.0
2010-02-01 12:00:00	QQQ	ETF	42.94	43.02	42.94	43.02	6048567.0
2010-02-01 12:30:00	QQQ	ETF	43.02	43.19	43.0022	43.13	8842140.0
2010-02-01 13:00:00	QQQ	ETF	43.13	43.21	43.08	43.175	4480566.0
2010-02-01 13:30:00	QQQ	ETF	43.175	43.23	43.12	43.19	4272386.0
2010-02-01 14:00:00	QQQ	ETF	43.191	43.24	43.12	43.18	4348343.0
2010-02-01 14:30:00	QQQ	ETF	43.2	43.27	43.18	43.2	4448145.0
2010-02-01 15:00:00	QQQ	ETF	43.2	43.24	43.11	43.1901	7866336.0

> showing 50 of 8,285 rows — these rows as CSV

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