PREVIEW / etf_30min / 2016-04-19

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-04-19.parquet
  size:    401 KB
  rows:    13,510

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-04-19 04:00:00	SPY	ETF	209.83	210.05	209.83	209.9	24206.0
2016-04-19 04:30:00	SPY	ETF	209.94	210.03	209.92	210.03	14334.0
2016-04-19 05:00:00	SPY	ETF	210.04	210.07	209.97	210.07	9650.0
2016-04-19 05:30:00	SPY	ETF	210.05	210.25	210.05	210.17	15697.0
2016-04-19 06:00:00	SPY	ETF	210.21	210.23	210.12	210.12	33742.0
2016-04-19 06:30:00	SPY	ETF	210.12	210.12	209.97	210.06	10982.0
2016-04-19 07:00:00	SPY	ETF	210.06	210.11	209.9	209.93	339351.0
2016-04-19 07:30:00	SPY	ETF	209.91	210.15	209.91	210.1	186716.0
2016-04-19 08:00:00	SPY	ETF	210.09	210.09	209.04	210.02	466228.0
2016-04-19 08:30:00	SPY	ETF	210.02	210.02	209.83	209.85	357646.0
2016-04-19 09:00:00	SPY	ETF	209.85	209.96	209.72	209.72	437072.0
2016-04-19 09:30:00	SPY	ETF	209.74	210.0	209.47	209.98	10711418.0
2016-04-19 10:00:00	SPY	ETF	209.98	210.2	209.92	209.966	7625483.0
2016-04-19 10:30:00	SPY	ETF	209.97	210.14	209.72	210.06	6715514.0
2016-04-19 11:00:00	SPY	ETF	210.06	210.17	209.735	209.77	4233929.0
2016-04-19 11:30:00	SPY	ETF	209.76	209.93	209.3	209.315	4801920.0
2016-04-19 12:00:00	SPY	ETF	209.315	209.395	208.97	209.195	5934392.0
2016-04-19 12:30:00	SPY	ETF	209.191	209.33	208.94	209.3199	5582891.0
2016-04-19 13:00:00	SPY	ETF	209.31	209.59	209.27	209.48	3749746.0
2016-04-19 13:30:00	SPY	ETF	209.481	209.72	209.38	209.67	4311823.0
2016-04-19 14:00:00	SPY	ETF	209.68	209.83	209.58	209.59	3999189.0
2016-04-19 14:30:00	SPY	ETF	209.58	209.77	209.49	209.57	4667332.0
2016-04-19 15:00:00	SPY	ETF	209.56	209.88	209.45	209.8	4828501.0
2016-04-19 15:30:00	SPY	ETF	209.8	209.9	209.67	209.87	9030106.0
2016-04-19 16:00:00	SPY	ETF	209.88	209.98	209.43	209.73	2696840.0
2016-04-19 16:30:00	SPY	ETF	209.74	209.84	209.73	209.84	314048.0
2016-04-19 17:00:00	SPY	ETF	209.83	209.85	209.76	209.78	97378.0
2016-04-19 17:30:00	SPY	ETF	209.79	209.82	209.78	209.82	38928.0
2016-04-19 18:00:00	SPY	ETF	209.82	209.82	209.7	209.71	71589.0
2016-04-19 18:30:00	SPY	ETF	209.71	209.71	209.54	209.58	144111.0
2016-04-19 19:00:00	SPY	ETF	209.64	209.64	209.55	209.55	8850.0
2016-04-19 19:30:00	SPY	ETF	209.59	209.62	209.48	209.53	58267.0
2016-04-19 04:00:00	QQQ	ETF	111.53	111.55	111.53	111.55	261.0
2016-04-19 05:00:00	QQQ	ETF	111.65	111.66	111.64	111.64	10620.0
2016-04-19 05:30:00	QQQ	ETF	111.69	111.77	111.69	111.77	1100.0
2016-04-19 06:00:00	QQQ	ETF	111.75	111.77	111.75	111.77	6249.0
2016-04-19 06:30:00	QQQ	ETF	111.72	111.72	111.66	111.66	1997.0
2016-04-19 07:00:00	QQQ	ETF	111.66	111.66	111.58	111.58	76746.0
2016-04-19 07:30:00	QQQ	ETF	111.58	111.74	111.57	111.72	30738.0
2016-04-19 08:00:00	QQQ	ETF	111.62	111.7	111.61	111.66	192380.0
2016-04-19 08:30:00	QQQ	ETF	111.62	111.64	111.49	111.51	120299.0
2016-04-19 09:00:00	QQQ	ETF	111.53	111.54	111.43	111.43	63124.0
2016-04-19 09:30:00	QQQ	ETF	111.44	111.44	110.52	110.68	6026002.0
2016-04-19 10:00:00	QQQ	ETF	110.67	110.92	110.581	110.85	5548350.0
2016-04-19 10:30:00	QQQ	ETF	110.85	111.02	110.71	110.86	2559286.0
2016-04-19 11:00:00	QQQ	ETF	110.8501	110.895	110.63	110.66	1151144.0
2016-04-19 11:30:00	QQQ	ETF	110.655	110.73	110.17	110.1805	1764883.0
2016-04-19 12:00:00	QQQ	ETF	110.19	110.25	109.97	110.105	2071663.0
2016-04-19 12:30:00	QQQ	ETF	110.1	110.27	109.88	110.2601	1544393.0
2016-04-19 13:00:00	QQQ	ETF	110.26	110.47	110.22	110.3918	945727.0

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

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