PREVIEW / etf_30min / 2010-10-20

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-10-20.parquet
  size:    265 KB
  rows:    8,706

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-10-20 04:00:00	SPY	ETF	117.11	117.14	117.0	117.0	3100.0
2010-10-20 04:30:00	SPY	ETF	117.1	117.32	117.1	117.32	16100.0
2010-10-20 05:00:00	SPY	ETF	117.31	117.34	117.22	117.22	1000.0
2010-10-20 05:30:00	SPY	ETF	117.25	117.26	117.25	117.26	300.0
2010-10-20 06:00:00	SPY	ETF	117.31	117.36	117.31	117.31	1500.0
2010-10-20 06:30:00	SPY	ETF	117.34	117.46	117.31	117.4	43069.0
2010-10-20 07:00:00	SPY	ETF	117.35	117.4	117.24	117.32	103789.0
2010-10-20 07:30:00	SPY	ETF	117.29	117.45	117.23	117.26	646317.0
2010-10-20 08:00:00	SPY	ETF	117.26	117.47	116.94	117.09	2208877.0
2010-10-20 08:30:00	SPY	ETF	117.09	117.29	116.97	116.99	1052725.0
2010-10-20 09:00:00	SPY	ETF	116.99	117.15	116.91	116.94	593501.0
2010-10-20 09:30:00	SPY	ETF	116.94	117.56	116.87	117.24	23921800.0
2010-10-20 10:00:00	SPY	ETF	117.23	117.36	116.95	117.26	17375975.0
2010-10-20 10:30:00	SPY	ETF	117.27	117.9	117.26	117.745	18265074.0
2010-10-20 11:00:00	SPY	ETF	117.744	118.04	117.63	118.0	13579168.0
2010-10-20 11:30:00	SPY	ETF	118.0	118.09	117.92	117.93	9077567.0
2010-10-20 12:00:00	SPY	ETF	117.93	118.38	117.91	118.25	12322613.0
2010-10-20 12:30:00	SPY	ETF	118.25	118.3	118.14	118.22	5664804.0
2010-10-20 13:00:00	SPY	ETF	118.22	118.4	118.11	118.26	8972654.0
2010-10-20 13:30:00	SPY	ETF	118.26	118.32	118.09	118.13	5941140.0
2010-10-20 14:00:00	SPY	ETF	118.12	118.33	117.95	118.18	13551137.0
2010-10-20 14:30:00	SPY	ETF	118.19	118.44	118.06	118.1901	10359803.0
2010-10-20 15:00:00	SPY	ETF	118.191	118.34	118.03	118.31	17871443.0
2010-10-20 15:30:00	SPY	ETF	118.31	118.32	117.79	117.87	23389140.0
2010-10-20 16:00:00	SPY	ETF	117.84	118.245	117.185	117.94	11003757.0
2010-10-20 16:30:00	SPY	ETF	117.94	118.17	117.927	118.12	377384.0
2010-10-20 17:00:00	SPY	ETF	118.11	118.11	118.0	118.05	185583.0
2010-10-20 17:30:00	SPY	ETF	118.05	118.11	118.01	118.11	30033.0
2010-10-20 18:00:00	SPY	ETF	118.12	118.17	117.87	118.15	191460.0
2010-10-20 18:30:00	SPY	ETF	118.14	118.15	118.11	118.15	8647.0
2010-10-20 19:00:00	SPY	ETF	118.13	118.17	118.12	118.13	26640.0
2010-10-20 19:30:00	SPY	ETF	118.14	118.21	118.13	118.21	49473.0
2010-10-20 04:00:00	QQQ	ETF	51.0	51.01	51.0	51.01	1159.0
2010-10-20 04:30:00	QQQ	ETF	51.09	51.09	51.09	51.09	100.0
2010-10-20 05:00:00	QQQ	ETF	51.09	51.09	51.04	51.04	300.0
2010-10-20 06:30:00	QQQ	ETF	51.1	51.1	51.07	51.07	100300.0
2010-10-20 07:00:00	QQQ	ETF	51.05	51.08	51.03	51.07	21404.0
2010-10-20 07:30:00	QQQ	ETF	51.04	51.12	51.02	51.08	591238.0
2010-10-20 08:00:00	QQQ	ETF	51.07	51.1	50.96	50.98	980154.0
2010-10-20 08:30:00	QQQ	ETF	50.99	51.03	50.92	50.93	164126.0
2010-10-20 09:00:00	QQQ	ETF	50.92	51.0	50.92	50.97	113692.0
2010-10-20 09:30:00	QQQ	ETF	50.96	51.19	50.94	51.06	9190777.0
2010-10-20 10:00:00	QQQ	ETF	51.07	51.1399	50.87	51.01	8523446.0
2010-10-20 10:30:00	QQQ	ETF	51.015	51.31	50.99	51.26	6973206.0
2010-10-20 11:00:00	QQQ	ETF	51.2562	51.45	51.18	51.4	6202464.0
2010-10-20 11:30:00	QQQ	ETF	51.39	51.48	51.39	51.4	5044333.0
2010-10-20 12:00:00	QQQ	ETF	51.393	51.57	51.39	51.5	3714632.0
2010-10-20 12:30:00	QQQ	ETF	51.49	51.51	51.38	51.403	2718737.0
2010-10-20 13:00:00	QQQ	ETF	51.41	51.5	51.35	51.44	4480577.0
2010-10-20 13:30:00	QQQ	ETF	51.44	51.46	51.35	51.3699	2069787.0

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

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