PREVIEW / etf_30min / 2016-01-28

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-01-28.parquet
  size:    395 KB
  rows:    13,400

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-01-28 04:00:00	SPY	ETF	189.7	189.9	189.21	189.35	23627.0
2016-01-28 04:30:00	SPY	ETF	189.41	189.84	189.38	189.46	16074.0
2016-01-28 05:00:00	SPY	ETF	189.5	189.52	189.06	189.13	12036.0
2016-01-28 05:30:00	SPY	ETF	189.11	189.36	188.98	189.15	23835.0
2016-01-28 06:00:00	SPY	ETF	189.12	189.12	188.68	188.85	40850.0
2016-01-28 06:30:00	SPY	ETF	188.92	189.06	187.91	188.14	152339.0
2016-01-28 07:00:00	SPY	ETF	188.16	188.55	187.86	188.53	251148.0
2016-01-28 07:30:00	SPY	ETF	188.57	188.79	188.26	188.73	256039.0
2016-01-28 08:00:00	SPY	ETF	188.73	188.97	188.0	188.66	497316.0
2016-01-28 08:30:00	SPY	ETF	188.68	189.57	188.06	189.56	1349176.0
2016-01-28 09:00:00	SPY	ETF	189.54	190.81	188.42	189.98	4377661.0
2016-01-28 09:30:00	SPY	ETF	189.96	190.2	189.37	189.702	16457734.0
2016-01-28 10:00:00	SPY	ETF	189.7	189.75	187.72	187.725	14959338.0
2016-01-28 10:30:00	SPY	ETF	187.72	188.49	187.16	188.37	14429386.0
2016-01-28 11:00:00	SPY	ETF	188.38	189.27	188.32	188.63	9750359.0
2016-01-28 11:30:00	SPY	ETF	188.63	188.72	187.77	187.79	8867468.0
2016-01-28 12:00:00	SPY	ETF	187.79	189.24	187.76	189.2	6362151.0
2016-01-28 12:30:00	SPY	ETF	189.205	189.76	189.07	189.25	8026059.0
2016-01-28 13:00:00	SPY	ETF	189.24	189.52	188.37	188.96	7154059.0
2016-01-28 13:30:00	SPY	ETF	188.95	189.42	188.66	188.7	8411487.0
2016-01-28 14:00:00	SPY	ETF	188.7	189.67	188.66	189.64	7246171.0
2016-01-28 14:30:00	SPY	ETF	189.65	189.84	188.89	189.21	6827788.0
2016-01-28 15:00:00	SPY	ETF	189.21	189.66	188.99	189.21	7344794.0
2016-01-28 15:30:00	SPY	ETF	189.2	189.67	188.94	189.14	12518431.0
2016-01-28 16:00:00	SPY	ETF	189.17	189.21	188.42	188.65	6490914.0
2016-01-28 16:30:00	SPY	ETF	188.65	188.86	188.4	188.81	370026.0
2016-01-28 17:00:00	SPY	ETF	188.75	188.8	188.59	188.65	75682.0
2016-01-28 17:30:00	SPY	ETF	188.65	188.65	188.43	188.43	84434.0
2016-01-28 18:00:00	SPY	ETF	188.44	188.68	188.3	188.68	204309.0
2016-01-28 18:30:00	SPY	ETF	188.64	188.74	188.51	188.72	70735.0
2016-01-28 19:00:00	SPY	ETF	188.72	188.83	188.64	188.7	40377.0
2016-01-28 19:30:00	SPY	ETF	188.66	188.79	188.42	188.51	104272.0
2016-01-28 20:00:00	SPY	ETF	189.1923	189.1923	189.1923	189.1923	537200.0
2016-01-28 04:00:00	QQQ	ETF	102.0	102.1	101.87	101.88	4347.0
2016-01-28 04:30:00	QQQ	ETF	102.1	102.19	102.04	102.14	7061.0
2016-01-28 05:00:00	QQQ	ETF	101.82	101.82	101.69	101.69	6600.0
2016-01-28 05:30:00	QQQ	ETF	101.62	101.71	101.62	101.71	800.0
2016-01-28 06:00:00	QQQ	ETF	101.65	101.68	101.53	101.6	5710.0
2016-01-28 06:30:00	QQQ	ETF	101.65	101.65	101.01	101.24	18460.0
2016-01-28 07:00:00	QQQ	ETF	101.1	101.49	101.07	101.49	100182.0
2016-01-28 07:30:00	QQQ	ETF	101.49	101.64	101.38	101.59	147561.0
2016-01-28 08:00:00	QQQ	ETF	101.14	101.65	101.03	101.54	105493.0
2016-01-28 08:30:00	QQQ	ETF	101.53	102.0	100.58	102.0	552177.0
2016-01-28 09:00:00	QQQ	ETF	102.0	102.49	101.84	102.19	1093026.0
2016-01-28 09:30:00	QQQ	ETF	102.19	102.29	101.64	101.76	6224012.0
2016-01-28 10:00:00	QQQ	ETF	101.76	101.78	100.56	100.57	5365166.0
2016-01-28 10:30:00	QQQ	ETF	100.57	101.34	100.26	101.245	4932144.0
2016-01-28 11:00:00	QQQ	ETF	101.25	101.76	101.195	101.42	2488915.0
2016-01-28 11:30:00	QQQ	ETF	101.42	101.46	100.88	100.97	2543860.0
2016-01-28 12:00:00	QQQ	ETF	100.97	101.9	100.95	101.8678	2160909.0

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

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