PREVIEW / etf_30min / 2010-04-30

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-04-30.parquet
  size:    260 KB
  rows:    8,535

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-30 04:00:00	SPY	ETF	121.17	121.18	121.08	121.08	10400.0
2010-04-30 04:30:00	SPY	ETF	121.08	121.19	121.08	121.19	16100.0
2010-04-30 05:00:00	SPY	ETF	121.16	121.19	121.1	121.1	6828.0
2010-04-30 05:30:00	SPY	ETF	121.11	121.15	121.0	121.15	32014.0
2010-04-30 06:00:00	SPY	ETF	121.15	121.16	121.11	121.16	8200.0
2010-04-30 06:30:00	SPY	ETF	121.08	121.1	120.82	120.82	32400.0
2010-04-30 07:00:00	SPY	ETF	120.86	121.13	120.8	121.13	413520.0
2010-04-30 07:30:00	SPY	ETF	121.13	121.21	121.13	121.18	299269.0
2010-04-30 08:00:00	SPY	ETF	121.18	121.19	120.86	121.18	456962.0
2010-04-30 08:30:00	SPY	ETF	121.17	121.18	120.65	120.88	1699790.0
2010-04-30 09:00:00	SPY	ETF	120.88	120.95	120.81	120.87	1740178.0
2010-04-30 09:30:00	SPY	ETF	120.88	121.01	120.55	120.56	25760839.0
2010-04-30 10:00:00	SPY	ETF	120.56	120.9	119.84	120.26	33616086.0
2010-04-30 10:30:00	SPY	ETF	120.265	120.74	120.11	120.55	22926883.0
2010-04-30 11:00:00	SPY	ETF	120.55	120.9	120.32	120.38	13015334.0
2010-04-30 11:30:00	SPY	ETF	120.37	120.58	120.33	120.51	8428785.0
2010-04-30 12:00:00	SPY	ETF	120.5	120.71	119.66	119.75	19509227.0
2010-04-30 12:30:00	SPY	ETF	119.75	119.87	119.34	119.45	17694820.0
2010-04-30 13:00:00	SPY	ETF	119.45	120.8367	119.31	119.72	15023040.0
2010-04-30 13:30:00	SPY	ETF	119.71	119.95	119.61	119.66	9233262.0
2010-04-30 14:00:00	SPY	ETF	119.67	120.8368	119.52	119.78	9511419.0
2010-04-30 14:30:00	SPY	ETF	119.78	119.795	119.19	119.3199	17537501.0
2010-04-30 15:00:00	SPY	ETF	119.31	119.5	119.17	119.32	17182102.0
2010-04-30 15:30:00	SPY	ETF	119.31	119.39	118.78	118.83	37550305.0
2010-04-30 16:00:00	SPY	ETF	118.84	120.74	118.78	119.09	11246549.0
2010-04-30 16:30:00	SPY	ETF	119.09	119.09	118.94	119.01	2301698.0
2010-04-30 17:00:00	SPY	ETF	119.01	119.05	118.98	119.01	93984.0
2010-04-30 17:30:00	SPY	ETF	119.01	119.01	118.8297	118.99	570694.0
2010-04-30 18:00:00	SPY	ETF	118.99	118.99	118.85	118.87	37941.0
2010-04-30 18:30:00	SPY	ETF	118.87	118.9	118.81	118.81	57950.0
2010-04-30 19:00:00	SPY	ETF	118.81	118.91	118.8	118.9	11682.0
2010-04-30 19:30:00	SPY	ETF	118.88	118.91	118.81	118.89	35969.0
2010-04-30 04:00:00	QQQ	ETF	50.34	50.34	50.34	50.34	600.0
2010-04-30 04:30:00	QQQ	ETF	50.35	50.35	50.35	50.35	1000.0
2010-04-30 05:00:00	QQQ	ETF	50.38	50.38	50.38	50.38	400.0
2010-04-30 05:30:00	QQQ	ETF	50.34	50.34	50.34	50.34	100.0
2010-04-30 06:00:00	QQQ	ETF	50.35	50.35	50.35	50.35	1000.0
2010-04-30 06:30:00	QQQ	ETF	50.24	50.24	50.23	50.23	5100.0
2010-04-30 07:00:00	QQQ	ETF	50.22	50.34	50.22	50.34	17900.0
2010-04-30 07:30:00	QQQ	ETF	50.35	50.37	50.35	50.37	20500.0
2010-04-30 08:00:00	QQQ	ETF	50.36	50.38	50.31	50.35	184197.0
2010-04-30 08:30:00	QQQ	ETF	50.33	50.36	50.27	50.27	187279.0
2010-04-30 09:00:00	QQQ	ETF	50.26	50.29	50.18	50.21	459990.0
2010-04-30 09:30:00	QQQ	ETF	50.21	50.29	50.05	50.06	7864647.0
2010-04-30 10:00:00	QQQ	ETF	50.05	50.07	49.82	49.94	14459188.0
2010-04-30 10:30:00	QQQ	ETF	49.95	50.07	49.85	49.98	7477485.0
2010-04-30 11:00:00	QQQ	ETF	49.98	50.03	49.83	49.85	5252467.0
2010-04-30 11:30:00	QQQ	ETF	49.84	49.92	49.82	49.881	4562647.0
2010-04-30 12:00:00	QQQ	ETF	49.89	49.91	49.52	49.541	8822226.0
2010-04-30 12:30:00	QQQ	ETF	49.55	49.61	49.36	49.4096	5678658.0

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

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