PREVIEW / etf_30min / 2015-03-05

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-03-05.parquet
  size:    366 KB
  rows:    12,497

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
2015-03-05 04:00:00	SPY	ETF	210.28	210.28	210.17	210.17	300.0
2015-03-05 04:30:00	SPY	ETF	210.2	210.23	210.16	210.2	1500.0
2015-03-05 05:00:00	SPY	ETF	210.25	210.31	210.25	210.3	1200.0
2015-03-05 05:30:00	SPY	ETF	210.21	210.32	210.21	210.32	5300.0
2015-03-05 06:00:00	SPY	ETF	210.31	210.45	210.31	210.45	9223.0
2015-03-05 06:30:00	SPY	ETF	210.44	210.55	210.38	210.41	5445.0
2015-03-05 07:00:00	SPY	ETF	210.39	210.57	210.34	210.52	167995.0
2015-03-05 07:30:00	SPY	ETF	210.52	210.57	210.44	210.57	249672.0
2015-03-05 08:00:00	SPY	ETF	210.51	210.87	210.31	210.69	327336.0
2015-03-05 08:30:00	SPY	ETF	210.7	210.74	210.42	210.58	511069.0
2015-03-05 09:00:00	SPY	ETF	210.6	210.75	210.48	210.63	333339.0
2015-03-05 09:30:00	SPY	ETF	210.62	210.65	210.12	210.56	8694969.0
2015-03-05 10:00:00	SPY	ETF	210.56	210.75	210.44	210.73	5481573.0
2015-03-05 10:30:00	SPY	ETF	210.73	210.8	210.64	210.675	4397659.0
2015-03-05 11:00:00	SPY	ETF	210.68	210.685	210.14	210.39	5594584.0
2015-03-05 11:30:00	SPY	ETF	210.39	210.68	210.375	210.62	3600387.0
2015-03-05 12:00:00	SPY	ETF	210.63	210.63	210.29	210.318	2474673.0
2015-03-05 12:30:00	SPY	ETF	210.32	210.41	209.85	209.955	6560842.0
2015-03-05 13:00:00	SPY	ETF	209.95	210.29	209.88	210.21	3007828.0
2015-03-05 13:30:00	SPY	ETF	210.21	210.39	210.19	210.38	2786191.0
2015-03-05 14:00:00	SPY	ETF	210.38	210.53	210.37	210.43	4121948.0
2015-03-05 14:30:00	SPY	ETF	210.439	210.64	210.33	210.53	4013834.0
2015-03-05 15:00:00	SPY	ETF	210.53	210.56	210.28	210.555	5552069.0
2015-03-05 15:30:00	SPY	ETF	210.55	210.62	210.32	210.47	12754425.0
2015-03-05 16:00:00	SPY	ETF	210.47	210.52	210.42	210.47	3870276.0
2015-03-05 16:30:00	SPY	ETF	210.47	210.56	210.43	210.48	834511.0
2015-03-05 17:00:00	SPY	ETF	210.47	210.49	207.5	210.46	3182184.0
2015-03-05 17:30:00	SPY	ETF	210.48	210.49	210.45	210.48	17526.0
2015-03-05 18:00:00	SPY	ETF	210.47	210.52	210.46	210.5	13626.0
2015-03-05 18:30:00	SPY	ETF	210.5	210.51	210.5	210.5	3050.0
2015-03-05 19:00:00	SPY	ETF	210.5	210.51	210.49	210.51	5100.0
2015-03-05 19:30:00	SPY	ETF	210.5	210.51	210.48	210.49	10900.0
2015-03-05 04:00:00	QQQ	ETF	108.6	108.6	108.6	108.6	100.0
2015-03-05 06:30:00	QQQ	ETF	108.88	108.88	108.71	108.71	3160.0
2015-03-05 07:00:00	QQQ	ETF	108.6	108.68	108.59	108.65	16016.0
2015-03-05 07:30:00	QQQ	ETF	108.62	108.63	108.59	108.63	9600.0
2015-03-05 08:00:00	QQQ	ETF	108.63	108.85	108.62	108.85	107172.0
2015-03-05 08:30:00	QQQ	ETF	108.8	108.8	108.63	108.69	106090.0
2015-03-05 09:00:00	QQQ	ETF	108.69	108.76	108.68	108.73	54069.0
2015-03-05 09:30:00	QQQ	ETF	108.73	108.8601	108.58	108.76	2412105.0
2015-03-05 10:00:00	QQQ	ETF	108.76	108.96	108.72	108.89	1662844.0
2015-03-05 10:30:00	QQQ	ETF	108.89	108.965	108.8	108.81	935789.0
2015-03-05 11:00:00	QQQ	ETF	108.82	108.82	108.43	108.62	1537754.0
2015-03-05 11:30:00	QQQ	ETF	108.63	108.77	108.62	108.73	493747.0
2015-03-05 12:00:00	QQQ	ETF	108.73	108.73	108.54	108.58	406943.0
2015-03-05 12:30:00	QQQ	ETF	108.585	108.63	108.19	108.2501	1025263.0
2015-03-05 13:00:00	QQQ	ETF	108.25	108.47	108.22	108.44	646155.0
2015-03-05 13:30:00	QQQ	ETF	108.44	108.59	108.43	108.59	696852.0
2015-03-05 14:00:00	QQQ	ETF	108.58	108.69	108.57	108.6161	539825.0
2015-03-05 14:30:00	QQQ	ETF	108.61	108.79	108.54	108.7399	481199.0

> showing 50 of 12,497 rows — these rows as CSV

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