PREVIEW / etf_30min / 2016-05-03

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-05-03.parquet
  size:    397 KB
  rows:    13,546

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-05-03 04:00:00	SPY	ETF	207.65	207.65	206.63	206.63	14819.0
2016-05-03 04:30:00	SPY	ETF	206.63	206.66	206.52	206.58	6715.0
2016-05-03 05:00:00	SPY	ETF	206.64	206.76	206.51	206.73	51219.0
2016-05-03 05:30:00	SPY	ETF	206.78	206.78	206.5	206.56	202601.0
2016-05-03 06:00:00	SPY	ETF	206.54	206.63	206.39	206.53	112555.0
2016-05-03 06:30:00	SPY	ETF	206.48	206.48	206.24	206.32	109540.0
2016-05-03 07:00:00	SPY	ETF	206.33	206.65	206.23	206.49	844265.0
2016-05-03 07:30:00	SPY	ETF	206.49	206.55	206.3	206.55	390932.0
2016-05-03 08:00:00	SPY	ETF	206.55	207.701	206.27	206.48	322081.0
2016-05-03 08:30:00	SPY	ETF	206.5	206.72	206.4	206.66	310025.0
2016-05-03 09:00:00	SPY	ETF	206.67	206.72	206.44	206.52	539771.0
2016-05-03 09:30:00	SPY	ETF	206.52	206.64	205.86	206.1	15549048.0
2016-05-03 10:00:00	SPY	ETF	206.1	206.11	205.51	205.93	10742634.0
2016-05-03 10:30:00	SPY	ETF	205.94	205.95	205.46	205.57	6489204.0
2016-05-03 11:00:00	SPY	ETF	205.57	205.8	205.42	205.49	5619602.0
2016-05-03 11:30:00	SPY	ETF	205.5	205.97	205.28	205.82	7736216.0
2016-05-03 12:00:00	SPY	ETF	205.825	205.94	205.59	205.76	4178584.0
2016-05-03 12:30:00	SPY	ETF	205.76	206.2	205.73	206.15	4614763.0
2016-05-03 13:00:00	SPY	ETF	206.14	206.48	206.06	206.4608	6324728.0
2016-05-03 13:30:00	SPY	ETF	206.465	206.8	206.39	206.44	6166568.0
2016-05-03 14:00:00	SPY	ETF	206.44	206.54	206.05	206.3115	5124970.0
2016-05-03 14:30:00	SPY	ETF	206.32	206.52	206.05	206.32	3511779.0
2016-05-03 15:00:00	SPY	ETF	206.32	206.39	205.9	206.0999	5317088.0
2016-05-03 15:30:00	SPY	ETF	206.09	206.32	205.75	206.15	13140742.0
2016-05-03 16:00:00	SPY	ETF	206.16	206.39	206.0	206.12	6015294.0
2016-05-03 16:30:00	SPY	ETF	206.12	206.24	206.12	206.24	1106781.0
2016-05-03 17:00:00	SPY	ETF	206.22	206.25	206.13	206.23	378496.0
2016-05-03 17:30:00	SPY	ETF	206.21	206.21	206.14	206.19	46265.0
2016-05-03 18:00:00	SPY	ETF	206.2	206.33	206.2	206.26	94624.0
2016-05-03 18:30:00	SPY	ETF	206.27	206.27	206.2	206.22	40780.0
2016-05-03 19:00:00	SPY	ETF	206.23	206.39	206.23	206.35	39590.0
2016-05-03 19:30:00	SPY	ETF	206.37	206.42	206.37	206.4	29684.0
2016-05-03 04:00:00	QQQ	ETF	106.12	106.12	105.99	105.99	1500.0
2016-05-03 04:30:00	QQQ	ETF	105.9	105.9	105.9	105.9	952.0
2016-05-03 05:30:00	QQQ	ETF	105.97	105.97	105.83	105.92	11476.0
2016-05-03 06:00:00	QQQ	ETF	105.87	105.9	105.8	105.9	8751.0
2016-05-03 06:30:00	QQQ	ETF	105.85	105.85	105.75	105.75	9300.0
2016-05-03 07:00:00	QQQ	ETF	105.77	105.98	105.77	105.94	7399.0
2016-05-03 07:30:00	QQQ	ETF	105.89	105.98	105.85	105.98	40209.0
2016-05-03 08:00:00	QQQ	ETF	105.9	106.05	105.85	105.9	59502.0
2016-05-03 08:30:00	QQQ	ETF	105.93	106.06	105.88	106.02	75840.0
2016-05-03 09:00:00	QQQ	ETF	106.02	106.06	105.9	105.94	58957.0
2016-05-03 09:30:00	QQQ	ETF	105.96	106.23	105.6	105.81	3129452.0
2016-05-03 10:00:00	QQQ	ETF	105.81	105.85	105.45	105.77	3343045.0
2016-05-03 10:30:00	QQQ	ETF	105.79	105.79	105.53	105.6478	1745602.0
2016-05-03 11:00:00	QQQ	ETF	105.64	105.79	105.53	105.665	1373035.0
2016-05-03 11:30:00	QQQ	ETF	105.65	105.86	105.47	105.73	1041237.0
2016-05-03 12:00:00	QQQ	ETF	105.74	105.79	105.5489	105.72	932705.0
2016-05-03 12:30:00	QQQ	ETF	105.73	106.089	105.71	106.046	947278.0
2016-05-03 13:00:00	QQQ	ETF	106.0462	106.27	105.98	106.2369	1256908.0

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

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