PREVIEW / etf_30min / 2016-10-26

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-10-26.parquet
  size:    399 KB
  rows:    13,516

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
2016-10-26 04:00:00	SPY	ETF	213.62	213.64	213.39	213.41	10147.0
2016-10-26 04:30:00	SPY	ETF	213.37	213.44	213.31	213.42	4657.0
2016-10-26 05:00:00	SPY	ETF	213.27	213.34	213.07	213.16	8006.0
2016-10-26 05:30:00	SPY	ETF	213.21	213.39	213.19	213.39	5418.0
2016-10-26 06:00:00	SPY	ETF	213.34	213.4	213.3	213.33	12595.0
2016-10-26 06:30:00	SPY	ETF	213.33	213.45	213.31	213.4	28887.0
2016-10-26 07:00:00	SPY	ETF	213.4	213.46	213.31	213.31	58943.0
2016-10-26 07:30:00	SPY	ETF	213.31	213.5	213.3	213.49	162630.0
2016-10-26 08:00:00	SPY	ETF	213.43	213.818	213.38	213.46	270240.0
2016-10-26 08:30:00	SPY	ETF	213.5	213.53	213.4	213.43	144251.0
2016-10-26 09:00:00	SPY	ETF	213.44	213.44	213.2	213.2	328043.0
2016-10-26 09:30:00	SPY	ETF	213.21	213.48	212.93	213.14	10893948.0
2016-10-26 10:00:00	SPY	ETF	213.145	213.36	213.02	213.26	5290915.0
2016-10-26 10:30:00	SPY	ETF	213.26	214.295	213.18	214.23	8671438.0
2016-10-26 11:00:00	SPY	ETF	214.2201	214.42	214.151	214.26	7214096.0
2016-10-26 11:30:00	SPY	ETF	214.2575	214.38	214.07	214.1	4228032.0
2016-10-26 12:00:00	SPY	ETF	214.095	214.19	214.04	214.07	3674240.0
2016-10-26 12:30:00	SPY	ETF	214.075	214.21	213.99	214.03	2443325.0
2016-10-26 13:00:00	SPY	ETF	214.03	214.11	213.72	213.82	2542423.0
2016-10-26 13:30:00	SPY	ETF	213.82	213.825	213.26	213.41	4384114.0
2016-10-26 14:00:00	SPY	ETF	213.41	213.6	213.15	213.49	4643763.0
2016-10-26 14:30:00	SPY	ETF	213.485	213.87	213.43	213.79	2819253.0
2016-10-26 15:00:00	SPY	ETF	213.79	213.99	213.63	213.8534	3251622.0
2016-10-26 15:30:00	SPY	ETF	213.85	213.95	213.71	213.74	7457334.0
2016-10-26 16:00:00	SPY	ETF	213.75	214.0	213.6893	213.77	4678348.0
2016-10-26 16:30:00	SPY	ETF	213.77	213.83	213.74	213.81	256367.0
2016-10-26 17:00:00	SPY	ETF	213.77	213.82	213.77	213.81	510055.0
2016-10-26 17:30:00	SPY	ETF	213.78	213.86	213.76	213.8	91508.0
2016-10-26 18:00:00	SPY	ETF	213.79	213.82	213.71	213.74	69460.0
2016-10-26 18:30:00	SPY	ETF	213.74	213.79	213.73	213.79	9241.0
2016-10-26 19:00:00	SPY	ETF	213.76	213.78	213.73	213.73	4869.0
2016-10-26 19:30:00	SPY	ETF	213.78	213.81	213.74	213.79	14448.0
2016-10-26 04:00:00	QQQ	ETF	118.78	118.78	118.6	118.6	5500.0
2016-10-26 05:00:00	QQQ	ETF	118.41	118.42	118.41	118.42	600.0
2016-10-26 05:30:00	QQQ	ETF	118.51	118.51	118.48	118.48	398.0
2016-10-26 06:00:00	QQQ	ETF	118.53	118.53	118.51	118.51	2905.0
2016-10-26 06:30:00	QQQ	ETF	118.49	118.49	118.49	118.49	8555.0
2016-10-26 07:00:00	QQQ	ETF	118.53	118.54	118.51	118.51	2500.0
2016-10-26 07:30:00	QQQ	ETF	118.51	118.58	118.51	118.58	115699.0
2016-10-26 08:00:00	QQQ	ETF	118.5	118.69	118.5	118.59	38402.0
2016-10-26 08:30:00	QQQ	ETF	118.61	118.65	118.57	118.57	44599.0
2016-10-26 09:00:00	QQQ	ETF	118.55	118.56	118.39	118.39	200683.0
2016-10-26 09:30:00	QQQ	ETF	118.41	118.51	118.08	118.23	2970208.0
2016-10-26 10:00:00	QQQ	ETF	118.23	118.49	118.15	118.37	1554141.0
2016-10-26 10:30:00	QQQ	ETF	118.375	118.85	118.27	118.82	1604810.0
2016-10-26 11:00:00	QQQ	ETF	118.83	119.03	118.825	118.87	1167317.0
2016-10-26 11:30:00	QQQ	ETF	118.86	118.9	118.69	118.72	554560.0
2016-10-26 12:00:00	QQQ	ETF	118.72	118.79	118.69	118.715	333033.0
2016-10-26 12:30:00	QQQ	ETF	118.72	118.8	118.64	118.66	947600.0
2016-10-26 13:00:00	QQQ	ETF	118.67	118.72	118.41	118.46	702160.0

> showing 50 of 13,516 rows — these rows as CSV

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