PREVIEW / etf_30min / 2018-09-26

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-09-26.parquet
  size:    473 KB
  rows:    16,305

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
2018-09-26 04:00:00	SPY	ETF	291.45	291.46	291.22	291.35	3402.0
2018-09-26 04:30:00	SPY	ETF	291.4	291.46	291.39	291.39	1730.0
2018-09-26 05:00:00	SPY	ETF	291.32	291.4	291.32	291.4	1100.0
2018-09-26 05:30:00	SPY	ETF	291.3	291.37	291.3	291.37	200.0
2018-09-26 06:00:00	SPY	ETF	291.37	291.4	291.35	291.35	1080.0
2018-09-26 06:30:00	SPY	ETF	291.3	291.48	291.3	291.4	16902.0
2018-09-26 07:00:00	SPY	ETF	291.4	291.4	291.32	291.4	11424.0
2018-09-26 07:30:00	SPY	ETF	291.37	291.38	291.17	291.17	56190.0
2018-09-26 08:00:00	SPY	ETF	291.34	291.36	291.06	291.21	75850.0
2018-09-26 08:30:00	SPY	ETF	291.16	291.19	291.1	291.15	118952.0
2018-09-26 09:00:00	SPY	ETF	291.12	291.12	290.84	290.89	229913.0
2018-09-26 09:30:00	SPY	ETF	290.91	291.31	290.86	291.13	3131081.0
2018-09-26 10:00:00	SPY	ETF	291.15	291.21	290.7	290.99	2411190.0
2018-09-26 10:30:00	SPY	ETF	290.99	291.39	290.96	291.315	2886111.0
2018-09-26 11:00:00	SPY	ETF	291.32	291.53	291.32	291.53	2050364.0
2018-09-26 11:30:00	SPY	ETF	291.52	291.55	291.35	291.405	1618360.0
2018-09-26 12:00:00	SPY	ETF	291.4	291.45	291.295	291.44	2580277.0
2018-09-26 12:30:00	SPY	ETF	291.43	291.63	291.42	291.63	1380105.0
2018-09-26 13:00:00	SPY	ETF	291.6269	291.66	291.51	291.51	1156914.0
2018-09-26 13:30:00	SPY	ETF	291.52	291.55	291.37	291.41	1890787.0
2018-09-26 14:00:00	SPY	ETF	291.41	292.24	291.33	291.93	8347117.0
2018-09-26 14:30:00	SPY	ETF	291.94	292.05	291.28	291.385	6218445.0
2018-09-26 15:00:00	SPY	ETF	291.39	291.59	291.025	291.33	4821998.0
2018-09-26 15:30:00	SPY	ETF	291.32	291.33	289.41	289.84	23178263.0
2018-09-26 16:00:00	SPY	ETF	289.84	289.88	289.43	289.82	14739332.0
2018-09-26 16:30:00	SPY	ETF	289.82	289.98	289.63	289.81	484643.0
2018-09-26 17:00:00	SPY	ETF	289.79	289.84	289.64	289.76	94332.0
2018-09-26 17:30:00	SPY	ETF	289.78	289.78	289.72	289.74	37980.0
2018-09-26 18:00:00	SPY	ETF	289.76	289.84	289.68	289.74	120411.0
2018-09-26 18:30:00	SPY	ETF	289.78	290.0	289.78	290.0	17719.0
2018-09-26 19:00:00	SPY	ETF	289.97	290.01	289.9699	290.0	7335.0
2018-09-26 19:30:00	SPY	ETF	289.98	290.0	289.88	289.99	22747.0
2018-09-26 04:00:00	QQQ	ETF	184.6	184.87	184.6	184.87	2031.0
2018-09-26 04:30:00	QQQ	ETF	184.91	184.92	184.9	184.91	1100.0
2018-09-26 05:00:00	QQQ	ETF	184.89	184.93	184.87	184.89	5927.0
2018-09-26 05:30:00	QQQ	ETF	184.92	184.92	184.8	184.83	6050.0
2018-09-26 06:00:00	QQQ	ETF	184.79	184.9	184.79	184.81	4625.0
2018-09-26 06:30:00	QQQ	ETF	184.76	184.87	184.75	184.75	9271.0
2018-09-26 07:00:00	QQQ	ETF	184.74	184.74	184.64	184.66	31856.0
2018-09-26 07:30:00	QQQ	ETF	184.65	184.7	184.49	184.49	85063.0
2018-09-26 08:00:00	QQQ	ETF	184.67	184.7499	184.43	184.55	98028.0
2018-09-26 08:30:00	QQQ	ETF	184.55	184.59	184.51	184.56	53650.0
2018-09-26 09:00:00	QQQ	ETF	184.58	184.58	184.22	184.25	198375.0
2018-09-26 09:30:00	QQQ	ETF	184.26	184.78	184.17	184.675	2589596.0
2018-09-26 10:00:00	QQQ	ETF	184.67	184.87	184.3707	184.6401	2101172.0
2018-09-26 10:30:00	QQQ	ETF	184.64	185.03	184.62	184.97	1791006.0
2018-09-26 11:00:00	QQQ	ETF	184.96	185.35	184.96	185.35	1447578.0
2018-09-26 11:30:00	QQQ	ETF	185.35	185.3899	185.18	185.24	860062.0
2018-09-26 12:00:00	QQQ	ETF	185.24	185.25	185.1	185.17	906584.0
2018-09-26 12:30:00	QQQ	ETF	185.17	185.23	184.98	185.21	1248254.0

> showing 50 of 16,305 rows — these rows as CSV

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