PREVIEW / etf_30min / 2015-08-20

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-08-20.parquet
  size:    409 KB
  rows:    13,749

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-08-20 04:00:00	SPY	ETF	207.45	207.46	207.14	207.24	13049.0
2015-08-20 04:30:00	SPY	ETF	207.19	207.27	206.62	206.8	22882.0
2015-08-20 05:00:00	SPY	ETF	206.92	206.92	206.08	206.08	73682.0
2015-08-20 05:30:00	SPY	ETF	206.2	206.81	206.18	206.72	143800.0
2015-08-20 06:00:00	SPY	ETF	206.75	206.79	206.49	206.64	128236.0
2015-08-20 06:30:00	SPY	ETF	206.64	206.64	206.34	206.4	149049.0
2015-08-20 07:00:00	SPY	ETF	206.46	206.58	206.21	206.39	634725.0
2015-08-20 07:30:00	SPY	ETF	206.39	206.74	206.34	206.68	275989.0
2015-08-20 08:00:00	SPY	ETF	206.69	206.74	206.27	206.6	474486.0
2015-08-20 08:30:00	SPY	ETF	206.61	207.13	206.61	206.87	1019199.0
2015-08-20 09:00:00	SPY	ETF	206.9	206.98	206.52	206.52	710605.0
2015-08-20 09:30:00	SPY	ETF	206.51	208.2865	206.22	206.35	20550038.0
2015-08-20 10:00:00	SPY	ETF	206.35	206.48	205.48	205.605	17792679.0
2015-08-20 10:30:00	SPY	ETF	205.61	206.37	205.47	206.12	12724461.0
2015-08-20 11:00:00	SPY	ETF	206.13	206.25	205.58	206.02	10321228.0
2015-08-20 11:30:00	SPY	ETF	206.02	206.17	205.71	206.16	6050530.0
2015-08-20 12:00:00	SPY	ETF	206.16	206.19	205.48	205.59	8046447.0
2015-08-20 12:30:00	SPY	ETF	205.59	206.1	204.97	205.1401	10226877.0
2015-08-20 13:00:00	SPY	ETF	205.15	205.75	204.99	205.582	11382107.0
2015-08-20 13:30:00	SPY	ETF	205.57	205.8	205.21	205.725	7040774.0
2015-08-20 14:00:00	SPY	ETF	205.72	205.725	205.0	205.05	10876929.0
2015-08-20 14:30:00	SPY	ETF	205.05	205.315	204.54	204.63	10311385.0
2015-08-20 15:00:00	SPY	ETF	204.63	205.0	204.56	204.915	11269345.0
2015-08-20 15:30:00	SPY	ETF	204.92	205.21	203.91	203.91	29780424.0
2015-08-20 16:00:00	SPY	ETF	203.92	206.45	203.17	203.25	13843409.0
2015-08-20 16:30:00	SPY	ETF	203.23	205.481	203.19	203.27	4834134.0
2015-08-20 17:00:00	SPY	ETF	203.27	203.35	203.15	203.16	238528.0
2015-08-20 17:30:00	SPY	ETF	203.15	203.34	203.14	203.32	204903.0
2015-08-20 18:00:00	SPY	ETF	203.32	203.44	203.28	203.36	124999.0
2015-08-20 18:30:00	SPY	ETF	203.36	203.42	203.23	203.39	160106.0
2015-08-20 19:00:00	SPY	ETF	203.36	203.41	203.26	203.38	74591.0
2015-08-20 19:30:00	SPY	ETF	203.33	203.5	203.33	203.457	105271.0
2015-08-20 04:00:00	QQQ	ETF	109.55	109.55	109.55	109.55	1000.0
2015-08-20 04:30:00	QQQ	ETF	109.4	109.4	109.31	109.31	1200.0
2015-08-20 05:00:00	QQQ	ETF	109.15	109.15	109.0	109.0	1100.0
2015-08-20 05:30:00	QQQ	ETF	109.28	109.34	109.28	109.31	6600.0
2015-08-20 06:00:00	QQQ	ETF	109.21	109.28	109.21	109.23	19872.0
2015-08-20 06:30:00	QQQ	ETF	109.25	109.25	109.12	109.12	600.0
2015-08-20 07:00:00	QQQ	ETF	109.2	109.2	109.1	109.14	21900.0
2015-08-20 07:30:00	QQQ	ETF	109.15	109.3	109.15	109.3	53150.0
2015-08-20 08:00:00	QQQ	ETF	109.28	109.32	109.12	109.24	69909.0
2015-08-20 08:30:00	QQQ	ETF	109.28	109.53	109.27	109.35	78340.0
2015-08-20 09:00:00	QQQ	ETF	109.38	109.41	109.12	109.12	132197.0
2015-08-20 09:30:00	QQQ	ETF	109.11	109.46	108.85	108.91	6938619.0
2015-08-20 10:00:00	QQQ	ETF	108.91	109.0	107.92	108.105	7987076.0
2015-08-20 10:30:00	QQQ	ETF	108.11	108.46	108.005	108.315	3344410.0
2015-08-20 11:00:00	QQQ	ETF	108.31	108.43	107.9	108.16	2180525.0
2015-08-20 11:30:00	QQQ	ETF	108.16	108.25	107.935	108.25	2333928.0
2015-08-20 12:00:00	QQQ	ETF	108.25	108.27	107.85	107.94	1840499.0
2015-08-20 12:30:00	QQQ	ETF	107.93	108.09	107.5	107.565	2677341.0

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

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