PREVIEW / etf_30min / 2017-08-21

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-08-21.parquet
  size:    421 KB
  rows:    14,432

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
2017-08-21 04:00:00	SPY	ETF	242.43	242.45	242.27	242.36	8128.0
2017-08-21 04:30:00	SPY	ETF	242.34	242.43	242.34	242.41	4150.0
2017-08-21 05:00:00	SPY	ETF	242.41	242.66	242.41	242.62	2300.0
2017-08-21 05:30:00	SPY	ETF	242.57	242.61	242.53	242.61	3200.0
2017-08-21 06:00:00	SPY	ETF	242.66	242.91	242.65	242.91	3335.0
2017-08-21 06:30:00	SPY	ETF	243.04	243.04	242.8	242.86	16300.0
2017-08-21 07:00:00	SPY	ETF	242.88	242.96	242.86	242.96	31376.0
2017-08-21 07:30:00	SPY	ETF	242.88	243.06	242.87	242.94	63685.0
2017-08-21 08:00:00	SPY	ETF	242.88	242.95	242.76	242.84	102841.0
2017-08-21 08:30:00	SPY	ETF	242.84	242.89	242.73	242.82	194828.0
2017-08-21 09:00:00	SPY	ETF	242.8	242.83	242.6	242.64	499127.0
2017-08-21 09:30:00	SPY	ETF	242.64	242.85	242.25	242.32	6000099.0
2017-08-21 10:00:00	SPY	ETF	242.33	242.36	241.83	242.12	7340246.0
2017-08-21 10:30:00	SPY	ETF	242.1	242.58	242.06	242.51	4473075.0
2017-08-21 11:00:00	SPY	ETF	242.5	242.83	242.3	242.65	3485733.0
2017-08-21 11:30:00	SPY	ETF	242.65	243.05	242.64	242.83	3626601.0
2017-08-21 12:00:00	SPY	ETF	242.83	243.17	242.81	243.15	2248272.0
2017-08-21 12:30:00	SPY	ETF	243.15	243.2	242.92	242.99	1837989.0
2017-08-21 13:00:00	SPY	ETF	242.99	243.0199	242.79	242.81	2162690.0
2017-08-21 13:30:00	SPY	ETF	242.81	242.9	242.59	242.63	3375326.0
2017-08-21 14:00:00	SPY	ETF	242.63	242.75	242.55	242.67	2529527.0
2017-08-21 14:30:00	SPY	ETF	242.67	242.78	242.48	242.68	2681979.0
2017-08-21 15:00:00	SPY	ETF	242.68	242.96	242.42	242.96	3412735.0
2017-08-21 15:30:00	SPY	ETF	242.95	243.15	242.89	242.93	8426856.0
2017-08-21 16:00:00	SPY	ETF	242.94	243.07	242.9	243.05	8362489.0
2017-08-21 16:30:00	SPY	ETF	243.04	243.09	242.9625	243.07	1581972.0
2017-08-21 17:00:00	SPY	ETF	243.06	243.07	242.71	243.06	203024.0
2017-08-21 17:30:00	SPY	ETF	243.06	243.07	242.9	243.04	1740227.0
2017-08-21 18:00:00	SPY	ETF	243.04	243.18	242.99	243.18	61227.0
2017-08-21 18:30:00	SPY	ETF	243.17	243.17	243.08	243.09	9438.0
2017-08-21 19:00:00	SPY	ETF	243.07	243.11	243.07	243.11	8676.0
2017-08-21 19:30:00	SPY	ETF	243.11	243.19	243.06	243.18	24133.0
2017-08-21 04:00:00	QQQ	ETF	141.03	141.03	140.93	140.93	1198.0
2017-08-21 04:30:00	QQQ	ETF	140.9	140.91	140.9	140.91	852.0
2017-08-21 05:00:00	QQQ	ETF	141.02	141.08	141.02	141.08	400.0
2017-08-21 05:30:00	QQQ	ETF	141.08	141.08	141.01	141.02	2050.0
2017-08-21 06:00:00	QQQ	ETF	141.07	141.29	141.07	141.29	7564.0
2017-08-21 06:30:00	QQQ	ETF	141.3	141.43	141.25	141.25	6863.0
2017-08-21 07:00:00	QQQ	ETF	141.29	141.33	141.28	141.33	70802.0
2017-08-21 07:30:00	QQQ	ETF	141.3	141.43	141.27	141.32	116821.0
2017-08-21 08:00:00	QQQ	ETF	141.31	141.34	141.24	141.32	101003.0
2017-08-21 08:30:00	QQQ	ETF	141.31	141.4	141.31	141.4	139839.0
2017-08-21 09:00:00	QQQ	ETF	141.4	141.42	141.21	141.23	37780.0
2017-08-21 09:30:00	QQQ	ETF	141.23	141.53	140.9	140.98	3832328.0
2017-08-21 10:00:00	QQQ	ETF	140.97	141.01	140.18	140.39	4169206.0
2017-08-21 10:30:00	QQQ	ETF	140.38	140.67	140.31	140.5501	2692002.0
2017-08-21 11:00:00	QQQ	ETF	140.555	140.85	140.31	140.77	1892117.0
2017-08-21 11:30:00	QQQ	ETF	140.77	141.2	140.765	141.03	2464019.0
2017-08-21 12:00:00	QQQ	ETF	141.03	141.31	140.98	141.21	1863090.0
2017-08-21 12:30:00	QQQ	ETF	141.2	141.26	141.0	141.08	1274042.0

> showing 50 of 14,432 rows — these rows as CSV

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