PREVIEW / etf_30min / 2015-10-27

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-10-27.parquet
  size:    375 KB
  rows:    12,633

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-10-27 04:00:00	SPY	ETF	206.71	206.71	206.38	206.38	51485.0
2015-10-27 04:30:00	SPY	ETF	206.44	206.53	206.44	206.53	409.0
2015-10-27 05:00:00	SPY	ETF	206.65	206.72	206.61	206.72	2708.0
2015-10-27 05:30:00	SPY	ETF	206.69	206.78	206.67	206.77	3416.0
2015-10-27 06:00:00	SPY	ETF	206.74	206.74	206.67	206.67	279.0
2015-10-27 06:30:00	SPY	ETF	206.66	206.77	206.66	206.73	2289.0
2015-10-27 07:00:00	SPY	ETF	206.72	206.73	206.58	206.67	20549.0
2015-10-27 07:30:00	SPY	ETF	206.72	206.72	206.65	206.66	15957.0
2015-10-27 08:00:00	SPY	ETF	206.61	206.73	206.42	206.52	189071.0
2015-10-27 08:30:00	SPY	ETF	206.46	206.52	206.27	206.4	385084.0
2015-10-27 09:00:00	SPY	ETF	206.4	206.41	206.09	206.19	551867.0
2015-10-27 09:30:00	SPY	ETF	206.2	206.72	206.13	206.6311	8164141.0
2015-10-27 10:00:00	SPY	ETF	206.63	206.69	206.03	206.2	7442189.0
2015-10-27 10:30:00	SPY	ETF	206.2	206.62	206.05	206.58	5888181.0
2015-10-27 11:00:00	SPY	ETF	206.58	207.0	206.51	206.58	4654555.0
2015-10-27 11:30:00	SPY	ETF	206.58	206.74	206.14	206.255	4576195.0
2015-10-27 12:00:00	SPY	ETF	206.2501	206.33	206.06	206.19	5019226.0
2015-10-27 12:30:00	SPY	ETF	206.19	206.39	206.1	206.13	2938957.0
2015-10-27 13:00:00	SPY	ETF	206.135	206.135	205.79	205.96	4693969.0
2015-10-27 13:30:00	SPY	ETF	205.97	206.15	205.85	205.985	3960390.0
2015-10-27 14:00:00	SPY	ETF	205.98	206.28	205.95	206.18	3981467.0
2015-10-27 14:30:00	SPY	ETF	206.175	206.34	206.02	206.07	4057591.0
2015-10-27 15:00:00	SPY	ETF	206.07	206.54	206.04	206.46	5636628.0
2015-10-27 15:30:00	SPY	ETF	206.46	206.59	206.28	206.58	8227386.0
2015-10-27 16:00:00	SPY	ETF	206.57	206.78	206.53	206.66	4172982.0
2015-10-27 16:30:00	SPY	ETF	206.66	207.08	206.42	206.98	2350476.0
2015-10-27 17:00:00	SPY	ETF	206.98	207.0	206.83	206.91	160658.0
2015-10-27 17:30:00	SPY	ETF	206.9	206.9	206.73	206.85	96249.0
2015-10-27 18:00:00	SPY	ETF	206.87	206.89	206.69	206.77	66451.0
2015-10-27 18:30:00	SPY	ETF	206.74	206.76	206.7	206.7	23918.0
2015-10-27 19:00:00	SPY	ETF	206.73	206.73	206.6	206.65	14827.0
2015-10-27 19:30:00	SPY	ETF	206.64	206.75	206.63	206.73	21066.0
2015-10-27 04:00:00	QQQ	ETF	112.48	112.48	112.44	112.44	18750.0
2015-10-27 06:00:00	QQQ	ETF	112.59	112.59	112.51	112.53	11400.0
2015-10-27 06:30:00	QQQ	ETF	112.61	112.65	112.61	112.64	899.0
2015-10-27 07:00:00	QQQ	ETF	112.6	112.69	112.53	112.69	24316.0
2015-10-27 07:30:00	QQQ	ETF	112.69	112.73	112.67	112.73	11500.0
2015-10-27 08:00:00	QQQ	ETF	112.74	112.75	112.66	112.66	21999.0
2015-10-27 08:30:00	QQQ	ETF	112.65	112.66	112.57	112.63	35362.0
2015-10-27 09:00:00	QQQ	ETF	112.62	112.64	112.52	112.55	138991.0
2015-10-27 09:30:00	QQQ	ETF	112.54	113.03	112.52	112.94	2805593.0
2015-10-27 10:00:00	QQQ	ETF	112.93	112.94	112.58	112.68	1613152.0
2015-10-27 10:30:00	QQQ	ETF	112.68	112.93	112.61	112.91	1526178.0
2015-10-27 11:00:00	QQQ	ETF	112.92	113.24	112.89	113.07	2236089.0
2015-10-27 11:30:00	QQQ	ETF	113.07	113.14	112.86	112.92	1760848.0
2015-10-27 12:00:00	QQQ	ETF	112.91	112.9799	112.76	112.79	1390853.0
2015-10-27 12:30:00	QQQ	ETF	112.78	112.955	112.72	112.82	978463.0
2015-10-27 13:00:00	QQQ	ETF	112.81	112.82	112.64	112.72	1309349.0
2015-10-27 13:30:00	QQQ	ETF	112.72	112.9	112.7	112.8005	934853.0
2015-10-27 14:00:00	QQQ	ETF	112.8	112.95	112.79	112.9157	1241830.0

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

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