PREVIEW / etf_30min / 2010-04-16

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-04-16.parquet
  size:    264 KB
  rows:    8,649

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-16 04:00:00	SPY	ETF	120.9	120.9	120.9	120.9	100.0
2010-04-16 04:30:00	SPY	ETF	121.0	121.1	120.98	121.1	1750.0
2010-04-16 05:00:00	SPY	ETF	121.13	121.15	121.12	121.15	2500.0
2010-04-16 05:30:00	SPY	ETF	121.1	121.12	121.1	121.12	14100.0
2010-04-16 06:00:00	SPY	ETF	121.12	121.12	120.96	120.98	7966.0
2010-04-16 06:30:00	SPY	ETF	120.99	121.07	120.95	120.97	81225.0
2010-04-16 07:00:00	SPY	ETF	121.04	121.22	121.04	121.13	225929.0
2010-04-16 07:30:00	SPY	ETF	121.11	121.11	121.0	121.08	203743.0
2010-04-16 08:00:00	SPY	ETF	121.09	121.18	121.02	121.09	966846.0
2010-04-16 08:30:00	SPY	ETF	121.09	121.17	120.75	120.91	1266904.0
2010-04-16 09:00:00	SPY	ETF	120.91	120.92	120.7	120.87	1549011.0
2010-04-16 09:30:00	SPY	ETF	120.86	121.08	120.49	120.54	30191968.0
2010-04-16 10:00:00	SPY	ETF	120.55	121.07	120.5	120.9	21996721.0
2010-04-16 10:30:00	SPY	ETF	120.91	121.03	119.74	120.04	54146149.0
2010-04-16 11:00:00	SPY	ETF	120.05	120.24	119.07	119.4	46809682.0
2010-04-16 11:30:00	SPY	ETF	119.4	119.59	119.07	119.2501	31639699.0
2010-04-16 12:00:00	SPY	ETF	119.26	119.29	118.94	119.15	16805061.0
2010-04-16 12:30:00	SPY	ETF	119.15	119.32	118.75	119.27	22161155.0
2010-04-16 13:00:00	SPY	ETF	119.27	121.285	119.17	119.195	17672864.0
2010-04-16 13:30:00	SPY	ETF	119.195	119.36	119.12	119.3283	10482285.0
2010-04-16 14:00:00	SPY	ETF	119.32	119.83	119.25	119.71	18353825.0
2010-04-16 14:30:00	SPY	ETF	119.7194	119.8	119.39	119.41	14968748.0
2010-04-16 15:00:00	SPY	ETF	119.41	119.58	119.175	119.44	17544359.0
2010-04-16 15:30:00	SPY	ETF	119.45	119.82	119.29	119.36	32488607.0
2010-04-16 16:00:00	SPY	ETF	119.38	121.01	119.06	119.42	9015076.0
2010-04-16 16:30:00	SPY	ETF	119.43	121.2844	119.34	119.46	6411053.0
2010-04-16 17:00:00	SPY	ETF	119.42	121.2844	119.4	119.5	2327482.0
2010-04-16 17:30:00	SPY	ETF	119.5	121.2844	119.41	119.42	6068877.0
2010-04-16 18:00:00	SPY	ETF	119.43	119.47	119.41	119.47	282245.0
2010-04-16 18:30:00	SPY	ETF	119.46	119.62	119.4	119.54	138994.0
2010-04-16 19:00:00	SPY	ETF	119.52	119.6	119.47	119.52	16922.0
2010-04-16 19:30:00	SPY	ETF	119.52	119.55	119.5	119.54	62123.0
2010-04-16 04:00:00	QQQ	ETF	49.98	49.98	49.98	49.98	100.0
2010-04-16 06:00:00	QQQ	ETF	49.97	49.97	49.97	49.97	205.0
2010-04-16 06:30:00	QQQ	ETF	49.98	49.98	49.98	49.98	795.0
2010-04-16 07:00:00	QQQ	ETF	50.02	50.04	50.0	50.0	22065.0
2010-04-16 07:30:00	QQQ	ETF	49.99	50.0	49.95	49.99	55552.0
2010-04-16 08:00:00	QQQ	ETF	49.99	50.01	49.98	50.01	425524.0
2010-04-16 08:30:00	QQQ	ETF	50.01	50.05	49.95	49.96	297870.0
2010-04-16 09:00:00	QQQ	ETF	49.96	50.13	49.89	49.95	588641.0
2010-04-16 09:30:00	QQQ	ETF	49.95	50.04	49.79	49.85	13525426.0
2010-04-16 10:00:00	QQQ	ETF	49.85	50.12	49.82	50.03	7767133.0
2010-04-16 10:30:00	QQQ	ETF	50.03	50.09	49.71	49.7938	16470137.0
2010-04-16 11:00:00	QQQ	ETF	49.79	49.87	49.56	49.64	15793545.0
2010-04-16 11:30:00	QQQ	ETF	49.64	49.71	49.43	49.5099	10053928.0
2010-04-16 12:00:00	QQQ	ETF	49.5	49.505	49.31	49.4	7778018.0
2010-04-16 12:30:00	QQQ	ETF	49.4	49.47	49.2	49.4399	9487486.0
2010-04-16 13:00:00	QQQ	ETF	49.44	49.55	49.42	49.43	6634040.0
2010-04-16 13:30:00	QQQ	ETF	49.44	49.465	49.35	49.4419	4819218.0
2010-04-16 14:00:00	QQQ	ETF	49.44	49.65	49.4301	49.56	4505298.0

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

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