PREVIEW / etf_30min / 2010-04-21

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-04-21.parquet
  size:    256 KB
  rows:    8,461

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-04-21 04:00:00	SPY	ETF	121.1	121.1	121.05	121.05	600.0
2010-04-21 05:30:00	SPY	ETF	121.11	121.11	121.04	121.11	5357.0
2010-04-21 06:00:00	SPY	ETF	121.04	121.04	120.86	120.92	11243.0
2010-04-21 06:30:00	SPY	ETF	120.85	120.9	120.79	120.79	33500.0
2010-04-21 07:00:00	SPY	ETF	120.81	120.84	120.76	120.78	108400.0
2010-04-21 07:30:00	SPY	ETF	120.79	120.86	120.67	120.82	515033.0
2010-04-21 08:00:00	SPY	ETF	120.84	120.96	120.75	120.86	1190525.0
2010-04-21 08:30:00	SPY	ETF	120.85	120.98	120.82	120.88	1113484.0
2010-04-21 09:00:00	SPY	ETF	120.87	121.01	120.87	120.96	1178209.0
2010-04-21 09:30:00	SPY	ETF	120.95	121.23	120.85	121.18	20779314.0
2010-04-21 10:00:00	SPY	ETF	121.18	121.19	120.8	120.85	14312123.0
2010-04-21 10:30:00	SPY	ETF	120.84	121.08	120.71	120.7875	16445467.0
2010-04-21 11:00:00	SPY	ETF	120.785	120.88	120.4799	120.56	17313079.0
2010-04-21 11:30:00	SPY	ETF	120.56	120.69	120.31	120.66	13437366.0
2010-04-21 12:00:00	SPY	ETF	120.66	120.82	120.5115	120.76	7024458.0
2010-04-21 12:30:00	SPY	ETF	120.77	120.99	120.63	120.7525	12503243.0
2010-04-21 13:00:00	SPY	ETF	120.75	120.81	120.55	120.67	8205374.0
2010-04-21 13:30:00	SPY	ETF	120.67	120.84	120.66	120.805	6315116.0
2010-04-21 14:00:00	SPY	ETF	120.81	120.83	120.16	120.22	14296164.0
2010-04-21 14:30:00	SPY	ETF	120.215	120.32	119.99	120.31	15815666.0
2010-04-21 15:00:00	SPY	ETF	120.31	120.49	120.29	120.37	12663329.0
2010-04-21 15:30:00	SPY	ETF	120.3601	120.89	120.36	120.65	20986164.0
2010-04-21 16:00:00	SPY	ETF	120.64	121.18	120.27	120.35	6817633.0
2010-04-21 16:30:00	SPY	ETF	120.34	120.35	120.11	120.23	551899.0
2010-04-21 17:00:00	SPY	ETF	120.24	120.26	120.19	120.22	100556.0
2010-04-21 17:30:00	SPY	ETF	120.23	120.24	120.18	120.22	12060.0
2010-04-21 18:00:00	SPY	ETF	120.22	120.24	120.19	120.23	20506.0
2010-04-21 18:30:00	SPY	ETF	120.24	120.28	120.22	120.25	33614.0
2010-04-21 19:00:00	SPY	ETF	120.25	120.25	120.21	120.22	21918.0
2010-04-21 19:30:00	SPY	ETF	120.22	120.32	120.21	120.31	51142.0
2010-04-21 04:00:00	QQQ	ETF	50.1	50.1	50.1	50.1	100.0
2010-04-21 05:00:00	QQQ	ETF	50.08	50.08	50.08	50.08	500.0
2010-04-21 06:00:00	QQQ	ETF	50.05	50.05	50.05	50.05	1900.0
2010-04-21 06:30:00	QQQ	ETF	50.01	50.01	50.0	50.0	53000.0
2010-04-21 07:00:00	QQQ	ETF	50.0	50.0	49.95	49.98	506606.0
2010-04-21 07:30:00	QQQ	ETF	49.97	50.03	49.93	50.03	299797.0
2010-04-21 08:00:00	QQQ	ETF	50.03	50.18	49.97	50.05	893639.0
2010-04-21 08:30:00	QQQ	ETF	50.04	50.09	50.04	50.09	610242.0
2010-04-21 09:00:00	QQQ	ETF	50.09	50.12	50.06	50.09	1333359.0
2010-04-21 09:30:00	QQQ	ETF	50.09	50.19	50.0	50.14	9826550.0
2010-04-21 10:00:00	QQQ	ETF	50.14	50.15	49.89	49.9199	8144558.0
2010-04-21 10:30:00	QQQ	ETF	49.91	50.08	49.865	49.92	8010661.0
2010-04-21 11:00:00	QQQ	ETF	49.92	49.96	49.75	49.81	5889108.0
2010-04-21 11:30:00	QQQ	ETF	49.81	49.91	49.725	49.88	4380317.0
2010-04-21 12:00:00	QQQ	ETF	49.89	49.95	49.86	49.92	1671069.0
2010-04-21 12:30:00	QQQ	ETF	49.93	50.02	49.91	49.96	2348171.0
2010-04-21 13:00:00	QQQ	ETF	49.95	49.98	49.7771	49.92	2337380.0
2010-04-21 13:30:00	QQQ	ETF	49.92	50.03	49.9	50.02	3680963.0
2010-04-21 14:00:00	QQQ	ETF	50.01	50.01	49.82	49.8405	3545309.0
2010-04-21 14:30:00	QQQ	ETF	49.85	49.91	49.77	49.9	4289570.0

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

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