PREVIEW / etf_30min / 2010-04-23

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-04-23.parquet
  size:    254 KB
  rows:    8,381

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-23 04:00:00	SPY	ETF	120.69	120.69	120.69	120.69	1000.0
2010-04-23 04:30:00	SPY	ETF	120.76	121.1	120.76	121.1	4400.0
2010-04-23 05:00:00	SPY	ETF	121.17	121.17	121.05	121.07	2900.0
2010-04-23 05:30:00	SPY	ETF	121.1	121.12	120.9	121.08	9454.0
2010-04-23 06:00:00	SPY	ETF	120.92	121.02	120.85	120.99	15100.0
2010-04-23 06:30:00	SPY	ETF	121.02	121.02	120.89	120.98	16400.0
2010-04-23 07:00:00	SPY	ETF	120.97	121.15	120.97	121.05	135096.0
2010-04-23 07:30:00	SPY	ETF	121.03	121.14	120.96	121.11	157754.0
2010-04-23 08:00:00	SPY	ETF	121.1	121.17	120.21	121.09	411856.0
2010-04-23 08:30:00	SPY	ETF	121.09	121.16	120.84	120.9	1556363.0
2010-04-23 09:00:00	SPY	ETF	120.89	121.02	120.89	120.94	744738.0
2010-04-23 09:30:00	SPY	ETF	120.94	121.01	120.63	120.94	23344388.0
2010-04-23 10:00:00	SPY	ETF	120.95	121.51	120.85	121.13	23979205.0
2010-04-23 10:30:00	SPY	ETF	121.1375	121.245	120.86	120.98	17047540.0
2010-04-23 11:00:00	SPY	ETF	120.97	121.135	120.75	120.87	12375228.0
2010-04-23 11:30:00	SPY	ETF	120.87	120.94	120.65	120.89	9705036.0
2010-04-23 12:00:00	SPY	ETF	120.89	121.07	120.885	121.04	6902835.0
2010-04-23 12:30:00	SPY	ETF	121.04	121.27	120.97	121.26	5252116.0
2010-04-23 13:00:00	SPY	ETF	121.26	121.34	121.14	121.2	7213365.0
2010-04-23 13:30:00	SPY	ETF	121.2	121.32	121.13	121.28	6219017.0
2010-04-23 14:00:00	SPY	ETF	121.29	121.41	121.21	121.36	5837781.0
2010-04-23 14:30:00	SPY	ETF	121.3501	121.64	121.27	121.6	9635003.0
2010-04-23 15:00:00	SPY	ETF	121.5925	121.71	121.0	121.61	9155208.0
2010-04-23 15:30:00	SPY	ETF	121.6117	121.86	121.53	121.8	23028364.0
2010-04-23 16:00:00	SPY	ETF	121.79	121.81	121.05	121.73	9220801.0
2010-04-23 16:30:00	SPY	ETF	121.72	121.72	120.71	121.68	236270.0
2010-04-23 17:00:00	SPY	ETF	121.68	121.79	121.67	121.71	73989.0
2010-04-23 17:30:00	SPY	ETF	121.68	121.72	121.68	121.7	95867.0
2010-04-23 18:00:00	SPY	ETF	121.69	121.73	121.67	121.7	21835.0
2010-04-23 18:30:00	SPY	ETF	121.7	121.71	121.68	121.69	20300.0
2010-04-23 19:00:00	SPY	ETF	121.71	121.71	121.66	121.7	3740.0
2010-04-23 19:30:00	SPY	ETF	121.7	121.72	121.65	121.71	27456.0
2010-04-23 05:00:00	QQQ	ETF	50.24	50.24	50.24	50.24	202.0
2010-04-23 06:00:00	QQQ	ETF	50.24	50.24	50.24	50.24	150.0
2010-04-23 06:30:00	QQQ	ETF	50.2	50.2	50.2	50.2	5100.0
2010-04-23 07:00:00	QQQ	ETF	50.22	50.25	50.22	50.24	33878.0
2010-04-23 07:30:00	QQQ	ETF	50.23	50.28	50.21	50.28	175145.0
2010-04-23 08:00:00	QQQ	ETF	50.27	50.4	50.26	50.39	309892.0
2010-04-23 08:30:00	QQQ	ETF	50.38	50.46	50.26	50.3	3761696.0
2010-04-23 09:00:00	QQQ	ETF	50.3	50.34	50.28	50.295	197729.0
2010-04-23 09:30:00	QQQ	ETF	50.3	50.42	50.21	50.3901	11779077.0
2010-04-23 10:00:00	QQQ	ETF	50.39	50.55	50.38	50.39	9010747.0
2010-04-23 10:30:00	QQQ	ETF	50.39	50.429	50.2	50.25	5817134.0
2010-04-23 11:00:00	QQQ	ETF	50.25	50.28	50.14	50.19	7472433.0
2010-04-23 11:30:00	QQQ	ETF	50.1899	50.25	50.09	50.22	5230549.0
2010-04-23 12:00:00	QQQ	ETF	50.22	50.28	50.2	50.2201	2978059.0
2010-04-23 12:30:00	QQQ	ETF	50.23	50.36	50.19	50.35	2930126.0
2010-04-23 13:00:00	QQQ	ETF	50.35	50.35	50.25	50.26	1466033.0
2010-04-23 13:30:00	QQQ	ETF	50.26	50.329	50.21	50.31	2377305.0
2010-04-23 14:00:00	QQQ	ETF	50.31	50.36	50.27	50.349	2067688.0

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

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