PREVIEW / etf_30min / 2019-09-17

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-09-17.parquet
  size:    499 KB
  rows:    17,185

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
2019-09-17 04:00:00	SPY	ETF	300.12	300.36	300.12	300.33	2160.0
2019-09-17 04:30:00	SPY	ETF	300.19	300.19	299.97	300.0	9300.0
2019-09-17 05:00:00	SPY	ETF	300.1	300.27	300.1	300.17	5682.0
2019-09-17 05:30:00	SPY	ETF	299.99	299.99	299.95	299.95	2401.0
2019-09-17 06:00:00	SPY	ETF	299.86	299.97	299.86	299.9	4200.0
2019-09-17 06:30:00	SPY	ETF	299.9	299.97	299.72	299.72	13020.0
2019-09-17 07:00:00	SPY	ETF	299.77	299.89	299.73	299.89	188248.0
2019-09-17 07:30:00	SPY	ETF	299.89	300.3	299.88	300.21	104048.0
2019-09-17 08:00:00	SPY	ETF	300.1999	300.1999	299.7	299.8001	181491.0
2019-09-17 08:30:00	SPY	ETF	299.8	299.85	299.48	299.83	172272.0
2019-09-17 09:00:00	SPY	ETF	299.81	300.16	299.51	299.93	2133590.0
2019-09-17 09:30:00	SPY	ETF	299.94	300.39	299.75	300.155	5592786.0
2019-09-17 10:00:00	SPY	ETF	300.155	300.25	299.83	300.17	2617727.0
2019-09-17 10:30:00	SPY	ETF	300.165	300.36	299.97	299.98	2182515.0
2019-09-17 11:00:00	SPY	ETF	299.98	300.57	299.97	300.27	2901026.0
2019-09-17 11:30:00	SPY	ETF	300.27	300.47	300.23	300.29	1439210.0
2019-09-17 12:00:00	SPY	ETF	300.295	300.445	299.98	300.12	1773925.0
2019-09-17 12:30:00	SPY	ETF	300.13	300.1375	299.93	300.0	2031648.0
2019-09-17 13:00:00	SPY	ETF	300.0	300.25	299.94	300.1	1103625.0
2019-09-17 13:30:00	SPY	ETF	300.09	300.6	300.08	300.28	1953877.0
2019-09-17 14:00:00	SPY	ETF	300.29	300.56	300.11	300.2	3036000.0
2019-09-17 14:30:00	SPY	ETF	300.195	300.37	300.1802	300.285	1768610.0
2019-09-17 15:00:00	SPY	ETF	300.29	300.45	300.16	300.44	2746171.0
2019-09-17 15:30:00	SPY	ETF	300.435	301.02	300.41	300.94	6118641.0
2019-09-17 16:00:00	SPY	ETF	300.95	301.0	300.84	300.89	2590679.0
2019-09-17 16:30:00	SPY	ETF	300.89	300.9691	300.8	300.94	757070.0
2019-09-17 17:00:00	SPY	ETF	300.91	300.9499	300.9	300.94	555039.0
2019-09-17 17:30:00	SPY	ETF	300.94	300.95	300.91	300.92	12582.0
2019-09-17 18:00:00	SPY	ETF	300.93	300.96	300.74	300.9	84464.0
2019-09-17 18:30:00	SPY	ETF	300.9	300.94	300.85	300.85	14782.0
2019-09-17 19:00:00	SPY	ETF	300.86	300.88	300.76	300.88	6213.0
2019-09-17 19:30:00	SPY	ETF	300.85	300.86	300.81	300.82	28014.0
2019-09-17 04:00:00	QQQ	ETF	191.5	191.68	191.5	191.56	7468.0
2019-09-17 04:30:00	QQQ	ETF	191.51	191.51	191.35	191.42	5724.0
2019-09-17 05:00:00	QQQ	ETF	191.5	191.6	191.5	191.6	1200.0
2019-09-17 05:30:00	QQQ	ETF	191.51	191.51	191.3	191.33	7200.0
2019-09-17 06:00:00	QQQ	ETF	191.34	191.43	191.27	191.43	13900.0
2019-09-17 06:30:00	QQQ	ETF	191.41	191.44	191.16	191.21	9190.0
2019-09-17 07:00:00	QQQ	ETF	191.2	191.42	191.17	191.42	29830.0
2019-09-17 07:30:00	QQQ	ETF	191.43	191.83	191.43	191.73	29515.0
2019-09-17 08:00:00	QQQ	ETF	191.22	191.73	191.08	191.48	33352.0
2019-09-17 08:30:00	QQQ	ETF	191.44	191.54	191.23	191.54	69600.0
2019-09-17 09:00:00	QQQ	ETF	191.54	191.75	191.31	191.68	84620.0
2019-09-17 09:30:00	QQQ	ETF	191.68	192.03	191.29	191.69	2130420.0
2019-09-17 10:00:00	QQQ	ETF	191.705	191.77	191.42	191.61	805840.0
2019-09-17 10:30:00	QQQ	ETF	191.61	191.81	191.5	191.52	569726.0
2019-09-17 11:00:00	QQQ	ETF	191.52	192.01	191.52	191.78	618944.0
2019-09-17 11:30:00	QQQ	ETF	191.78	191.96	191.76	191.82	427001.0
2019-09-17 12:00:00	QQQ	ETF	191.83	191.96	191.65	191.75	552253.0
2019-09-17 12:30:00	QQQ	ETF	191.75	191.77	191.55	191.6867	515765.0

> showing 50 of 17,185 rows — these rows as CSV

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