PREVIEW / etf_30min / 2016-06-15

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-06-15.parquet
  size:    387 KB
  rows:    13,178

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-06-15 04:00:00	SPY	ETF	208.25	208.42	208.17	208.38	27835.0
2016-06-15 04:30:00	SPY	ETF	208.39	208.64	208.39	208.48	17431.0
2016-06-15 05:00:00	SPY	ETF	208.66	208.75	208.63	208.67	6245.0
2016-06-15 05:30:00	SPY	ETF	208.64	208.65	208.49	208.58	7337.0
2016-06-15 06:00:00	SPY	ETF	208.57	208.64	208.48	208.49	16713.0
2016-06-15 06:30:00	SPY	ETF	208.49	208.57	208.41	208.51	49634.0
2016-06-15 07:00:00	SPY	ETF	208.48	208.5	208.27	208.31	181330.0
2016-06-15 07:30:00	SPY	ETF	208.39	208.47	208.27	208.42	238401.0
2016-06-15 08:00:00	SPY	ETF	208.38	208.53	207.69	208.51	361822.0
2016-06-15 08:30:00	SPY	ETF	208.49	208.56	208.04	208.38	280569.0
2016-06-15 09:00:00	SPY	ETF	208.38	208.54	208.15	208.54	844667.0
2016-06-15 09:30:00	SPY	ETF	208.54	208.79	208.34	208.64	9887481.0
2016-06-15 10:00:00	SPY	ETF	208.64	208.95	208.59	208.6	6039898.0
2016-06-15 10:30:00	SPY	ETF	208.61	208.95	208.605	208.7189	6183695.0
2016-06-15 11:00:00	SPY	ETF	208.72	208.93	208.48	208.48	5650619.0
2016-06-15 11:30:00	SPY	ETF	208.49	208.75	208.41	208.71	4666423.0
2016-06-15 12:00:00	SPY	ETF	208.71	208.75	208.52	208.62	3388773.0
2016-06-15 12:30:00	SPY	ETF	208.615	208.71	208.42	208.43	4501874.0
2016-06-15 13:00:00	SPY	ETF	208.43	208.65	208.42	208.63	3092495.0
2016-06-15 13:30:00	SPY	ETF	208.63	208.91	208.6	208.8	3445682.0
2016-06-15 14:00:00	SPY	ETF	208.82	209.36	208.45	208.475	13776582.0
2016-06-15 14:30:00	SPY	ETF	208.46	208.95	208.27	208.8	7128774.0
2016-06-15 15:00:00	SPY	ETF	208.8	208.92	208.62	208.84	5865260.0
2016-06-15 15:30:00	SPY	ETF	208.83	208.89	207.53	207.75	20121159.0
2016-06-15 16:00:00	SPY	ETF	207.75	207.82	207.62	207.68	7400268.0
2016-06-15 16:30:00	SPY	ETF	207.68	207.69	207.59	207.65	798544.0
2016-06-15 17:00:00	SPY	ETF	207.63	207.78	207.51	207.56	3918334.0
2016-06-15 17:30:00	SPY	ETF	207.55	207.69	207.51	207.63	187609.0
2016-06-15 18:00:00	SPY	ETF	207.64	207.65	207.44	207.49	64580.0
2016-06-15 18:30:00	SPY	ETF	207.49	207.64	207.49	207.6	29895.0
2016-06-15 19:00:00	SPY	ETF	207.6	207.8	207.55	207.75	55841.0
2016-06-15 19:30:00	SPY	ETF	207.73	207.89	207.73	207.82	74486.0
2016-06-15 04:00:00	QQQ	ETF	108.17	108.24	108.17	108.24	1200.0
2016-06-15 04:30:00	QQQ	ETF	108.38	108.41	108.38	108.41	4599.0
2016-06-15 05:00:00	QQQ	ETF	108.42	108.42	108.41	108.42	5700.0
2016-06-15 05:30:00	QQQ	ETF	108.43	108.43	108.32	108.34	45498.0
2016-06-15 06:00:00	QQQ	ETF	108.35	108.41	108.34	108.34	6731.0
2016-06-15 06:30:00	QQQ	ETF	108.29	108.33	108.25	108.33	4899.0
2016-06-15 07:00:00	QQQ	ETF	108.31	108.31	108.2	108.2	21392.0
2016-06-15 07:30:00	QQQ	ETF	108.27	108.28	108.22	108.27	54999.0
2016-06-15 08:00:00	QQQ	ETF	108.25	108.33	108.22	108.31	65069.0
2016-06-15 08:30:00	QQQ	ETF	108.31	108.34	108.03	108.25	73904.0
2016-06-15 09:00:00	QQQ	ETF	108.23	108.33	108.17	108.33	60259.0
2016-06-15 09:30:00	QQQ	ETF	108.33	108.36	108.13	108.2	1850339.0
2016-06-15 10:00:00	QQQ	ETF	108.19	108.37	108.019	108.05	1147397.0
2016-06-15 10:30:00	QQQ	ETF	108.06	108.32	108.055	108.22	989523.0
2016-06-15 11:00:00	QQQ	ETF	108.22	108.3311	107.93	107.94	948895.0
2016-06-15 11:30:00	QQQ	ETF	107.93	108.21	107.92	108.21	851245.0
2016-06-15 12:00:00	QQQ	ETF	108.2	108.22	108.05	108.16	462639.0
2016-06-15 12:30:00	QQQ	ETF	108.16	108.21	108.0167	108.0167	556711.0

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

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