PREVIEW / etf_30min / 2010-11-24

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-11-24.parquet
  size:    255 KB
  rows:    8,642

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-11-24 04:00:00	SPY	ETF	118.2	118.38	118.11	118.31	5100.0
2010-11-24 04:30:00	SPY	ETF	118.28	118.33	118.2	118.2	11300.0
2010-11-24 05:00:00	SPY	ETF	118.15	118.54	118.15	118.48	19600.0
2010-11-24 05:30:00	SPY	ETF	118.47	118.67	118.47	118.67	1300.0
2010-11-24 06:00:00	SPY	ETF	118.65	118.75	118.65	118.75	9300.0
2010-11-24 06:30:00	SPY	ETF	118.83	118.83	118.57	118.57	78843.0
2010-11-24 07:00:00	SPY	ETF	118.54	118.79	118.43	118.68	376937.0
2010-11-24 07:30:00	SPY	ETF	118.69	118.75	118.55	118.69	140518.0
2010-11-24 08:00:00	SPY	ETF	118.69	118.97	118.63	118.92	888101.0
2010-11-24 08:30:00	SPY	ETF	119.0	119.47	118.74	119.19	3279329.0
2010-11-24 09:00:00	SPY	ETF	119.17	119.25	119.14	119.2	822130.0
2010-11-24 09:30:00	SPY	ETF	119.2	119.66	119.18	119.54	21218803.0
2010-11-24 10:00:00	SPY	ETF	119.54	119.9	119.32	119.8	15317660.0
2010-11-24 10:30:00	SPY	ETF	119.8	120.04	119.76	119.88	10611031.0
2010-11-24 11:00:00	SPY	ETF	119.8875	120.01	119.78	119.85	6754874.0
2010-11-24 11:30:00	SPY	ETF	119.855	119.97	119.75	119.905	6170586.0
2010-11-24 12:00:00	SPY	ETF	119.9017	120.02	119.87	120.0	6049899.0
2010-11-24 12:30:00	SPY	ETF	120.01	120.08	119.9	120.0	4259153.0
2010-11-24 13:00:00	SPY	ETF	120.0	120.17	119.95	120.14	4778734.0
2010-11-24 13:30:00	SPY	ETF	120.14	120.17	120.07	120.09	3766109.0
2010-11-24 14:00:00	SPY	ETF	120.08	120.12	119.89	120.01	4109183.0
2010-11-24 14:30:00	SPY	ETF	120.015	120.1	119.99	120.05	5096682.0
2010-11-24 15:00:00	SPY	ETF	120.04	120.22	120.02	120.1225	7411410.0
2010-11-24 15:30:00	SPY	ETF	120.12	120.23	119.94	120.18	22956368.0
2010-11-24 16:00:00	SPY	ETF	120.19	120.22	119.475	120.15	8829841.0
2010-11-24 16:30:00	SPY	ETF	120.11	120.15	120.01	120.05	1557957.0
2010-11-24 17:00:00	SPY	ETF	120.03	120.08	119.9869	120.07	91040.0
2010-11-24 17:30:00	SPY	ETF	120.07	120.15	120.07	120.08	24213.0
2010-11-24 18:00:00	SPY	ETF	120.08	120.15	120.04	120.12	35437.0
2010-11-24 18:30:00	SPY	ETF	120.13	120.15	120.04	120.11	13233.0
2010-11-24 19:00:00	SPY	ETF	120.13	120.13	120.01	120.03	44600.0
2010-11-24 19:30:00	SPY	ETF	120.05	120.06	119.96	120.03	33720.0
2010-11-24 04:00:00	QQQ	ETF	52.05	52.05	52.05	52.05	200.0
2010-11-24 05:30:00	QQQ	ETF	52.2	52.2	52.2	52.2	200.0
2010-11-24 06:00:00	QQQ	ETF	52.22	52.25	52.22	52.25	1250.0
2010-11-24 06:30:00	QQQ	ETF	52.2	52.21	52.2	52.21	300.0
2010-11-24 07:00:00	QQQ	ETF	52.15	52.24	52.15	52.21	11100.0
2010-11-24 07:30:00	QQQ	ETF	52.23	52.24	52.19	52.24	7500.0
2010-11-24 08:00:00	QQQ	ETF	52.23	52.48	52.23	52.48	472101.0
2010-11-24 08:30:00	QQQ	ETF	52.48	52.6	52.29	52.54	800390.0
2010-11-24 09:00:00	QQQ	ETF	52.53	52.6	52.51	52.58	471266.0
2010-11-24 09:30:00	QQQ	ETF	52.58	52.86	52.56	52.79	8712893.0
2010-11-24 10:00:00	QQQ	ETF	52.79	53.15	52.7	53.12	8152784.0
2010-11-24 10:30:00	QQQ	ETF	53.12	53.2	53.07	53.15	3580620.0
2010-11-24 11:00:00	QQQ	ETF	53.1401	53.19	53.09	53.14	2878995.0
2010-11-24 11:30:00	QQQ	ETF	53.15	53.16	53.06	53.125	1791714.0
2010-11-24 12:00:00	QQQ	ETF	53.125	53.17	53.12	53.1462	1545577.0
2010-11-24 12:30:00	QQQ	ETF	53.14	53.18	53.11	53.17	1151543.0
2010-11-24 13:00:00	QQQ	ETF	53.16	53.25	53.14	53.23	1313030.0
2010-11-24 13:30:00	QQQ	ETF	53.23	53.25	53.14	53.15	853647.0

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

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