PREVIEW / etf_30min / 2017-06-05

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-06-05.parquet
  size:    425 KB
  rows:    14,826

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-06-05 04:00:00	SPY	ETF	243.97	244.09	243.93	243.96	12743.0
2017-06-05 04:30:00	SPY	ETF	244.01	244.05	244.01	244.05	3000.0
2017-06-05 05:00:00	SPY	ETF	244.05	244.15	244.05	244.07	2000.0
2017-06-05 05:30:00	SPY	ETF	244.08	244.08	244.02	244.02	1000.0
2017-06-05 06:00:00	SPY	ETF	244.03	244.03	244.03	244.03	400.0
2017-06-05 06:30:00	SPY	ETF	244.05	244.05	243.92	243.95	17338.0
2017-06-05 07:00:00	SPY	ETF	243.93	244.01	243.84	243.91	93776.0
2017-06-05 07:30:00	SPY	ETF	243.94	243.94	243.88	243.91	21654.0
2017-06-05 08:00:00	SPY	ETF	243.88	243.94	243.86	243.93	37379.0
2017-06-05 08:30:00	SPY	ETF	243.94	243.96	243.88	243.91	47778.0
2017-06-05 09:00:00	SPY	ETF	243.91	244.02	243.89	243.98	312708.0
2017-06-05 09:30:00	SPY	ETF	243.97	244.13	243.76	244.1	4372507.0
2017-06-05 10:00:00	SPY	ETF	244.1	244.3	244.06	244.14	2991753.0
2017-06-05 10:30:00	SPY	ETF	244.14	244.25	244.08	244.1	1962289.0
2017-06-05 11:00:00	SPY	ETF	244.1	244.14	243.88	243.92	2660609.0
2017-06-05 11:30:00	SPY	ETF	243.91	244.12	243.86	244.105	1964087.0
2017-06-05 12:00:00	SPY	ETF	244.11	244.24	244.1	244.15	1608365.0
2017-06-05 12:30:00	SPY	ETF	244.145	244.18	244.0144	244.115	2663890.0
2017-06-05 13:00:00	SPY	ETF	244.11	244.265	244.11	244.2196	1212804.0
2017-06-05 13:30:00	SPY	ETF	244.21	244.22	244.06	244.08	1267106.0
2017-06-05 14:00:00	SPY	ETF	244.08	244.15	244.02	244.095	1124222.0
2017-06-05 14:30:00	SPY	ETF	244.1	244.16	244.05	244.085	1262212.0
2017-06-05 15:00:00	SPY	ETF	244.09	244.165	244.03	244.15	1649642.0
2017-06-05 15:30:00	SPY	ETF	244.14	244.19	243.91	243.965	5599297.0
2017-06-05 16:00:00	SPY	ETF	243.97	244.0607	243.82	243.85	9512718.0
2017-06-05 16:30:00	SPY	ETF	243.84	244.21	243.83	243.9	152048.0
2017-06-05 17:00:00	SPY	ETF	243.9	243.99	243.85	243.86	1081096.0
2017-06-05 17:30:00	SPY	ETF	243.88	243.89	243.85	243.85	8193.0
2017-06-05 18:00:00	SPY	ETF	243.85	243.87	243.82	243.86	15661.0
2017-06-05 18:30:00	SPY	ETF	243.86	243.89	243.86	243.89	4181.0
2017-06-05 19:00:00	SPY	ETF	243.89	243.89	243.87	243.87	2351.0
2017-06-05 19:30:00	SPY	ETF	243.87	243.88	243.86	243.88	11408.0
2017-06-05 04:00:00	QQQ	ETF	143.4	143.4	143.4	143.4	2600.0
2017-06-05 04:30:00	QQQ	ETF	143.45	143.45	143.44	143.44	555.0
2017-06-05 05:00:00	QQQ	ETF	143.44	143.52	143.44	143.52	350.0
2017-06-05 06:00:00	QQQ	ETF	143.44	143.44	143.44	143.44	1100.0
2017-06-05 06:30:00	QQQ	ETF	143.44	143.44	143.4	143.42	7500.0
2017-06-05 07:00:00	QQQ	ETF	143.37	143.41	143.35	143.36	12720.0
2017-06-05 07:30:00	QQQ	ETF	143.38	143.39	143.37	143.39	14514.0
2017-06-05 08:00:00	QQQ	ETF	143.37	143.39	143.35	143.39	41528.0
2017-06-05 08:30:00	QQQ	ETF	143.4	143.42	143.36	143.39	10290.0
2017-06-05 09:00:00	QQQ	ETF	143.38	143.47	143.36	143.45	132892.0
2017-06-05 09:30:00	QQQ	ETF	143.44	143.62	143.23	143.54	1945575.0
2017-06-05 10:00:00	QQQ	ETF	143.53	143.61	143.43	143.56	746118.0
2017-06-05 10:30:00	QQQ	ETF	143.57	143.68	143.39	143.4	848956.0
2017-06-05 11:00:00	QQQ	ETF	143.41	143.54	143.3	143.315	1488133.0
2017-06-05 11:30:00	QQQ	ETF	143.32	143.459	143.295	143.44	988327.0
2017-06-05 12:00:00	QQQ	ETF	143.44	143.5	143.415	143.43	641750.0
2017-06-05 12:30:00	QQQ	ETF	143.43	143.44	143.31	143.37	674543.0
2017-06-05 13:00:00	QQQ	ETF	143.365	143.48	143.34	143.47	313671.0

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

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