PREVIEW / etf_30min / 2019-03-08

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-03-08.parquet
  size:    496 KB
  rows:    17,440

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-03-08 04:00:00	SPY	ETF	274.15	274.38	274.15	274.27	3700.0
2019-03-08 04:30:00	SPY	ETF	274.28	274.36	274.06	274.07	4075.0
2019-03-08 05:00:00	SPY	ETF	274.01	274.08	273.75	273.86	8800.0
2019-03-08 05:30:00	SPY	ETF	273.99	274.26	273.96	274.23	48550.0
2019-03-08 06:00:00	SPY	ETF	274.09	274.17	274.06	274.13	10855.0
2019-03-08 06:30:00	SPY	ETF	274.18	274.24	273.85	273.85	8133.0
2019-03-08 07:00:00	SPY	ETF	273.94	274.15	273.94	274.1	37274.0
2019-03-08 07:30:00	SPY	ETF	274.1	274.1	273.77	273.77	147397.0
2019-03-08 08:00:00	SPY	ETF	273.9501	275.01	273.72	274.09	310107.0
2019-03-08 08:30:00	SPY	ETF	273.89	273.9	272.78	273.01	1479870.0
2019-03-08 09:00:00	SPY	ETF	273.0	273.06	272.5	272.93	749473.0
2019-03-08 09:30:00	SPY	ETF	272.94	273.4599	272.5501	272.97	12186078.0
2019-03-08 10:00:00	SPY	ETF	272.97	273.2199	272.42	273.08	8469726.0
2019-03-08 10:30:00	SPY	ETF	273.08	273.89	272.72	273.2	6288915.0
2019-03-08 11:00:00	SPY	ETF	273.21	273.84	272.985	273.63	4724435.0
2019-03-08 11:30:00	SPY	ETF	273.63	273.85	273.21	273.22	3157304.0
2019-03-08 12:00:00	SPY	ETF	273.22	273.285	272.86	273.155	3297971.0
2019-03-08 12:30:00	SPY	ETF	273.1569	273.2	272.49	272.55	3407077.0
2019-03-08 13:00:00	SPY	ETF	272.5585	272.8599	272.5	272.78	3342700.0
2019-03-08 13:30:00	SPY	ETF	272.7766	273.18	272.62	273.02	2404131.0
2019-03-08 14:00:00	SPY	ETF	273.02	273.39	272.76	273.31	3266673.0
2019-03-08 14:30:00	SPY	ETF	273.31	274.19	273.29	273.8	4093816.0
2019-03-08 15:00:00	SPY	ETF	273.7985	274.09	273.32	273.37	6065665.0
2019-03-08 15:30:00	SPY	ETF	273.36	274.65	273.28	274.525	13643171.0
2019-03-08 16:00:00	SPY	ETF	274.52	274.96	274.41	274.95	5254394.0
2019-03-08 16:30:00	SPY	ETF	274.96	275.05	274.46	275.02	823633.0
2019-03-08 17:00:00	SPY	ETF	275.02	275.06	274.95	275.04	1300674.0
2019-03-08 17:30:00	SPY	ETF	275.05	275.07	274.86	275.01	150542.0
2019-03-08 18:00:00	SPY	ETF	274.93	275.0	274.9	274.93	26571.0
2019-03-08 18:30:00	SPY	ETF	274.92	274.99	274.89	274.96	16013.0
2019-03-08 19:00:00	SPY	ETF	274.98	275.02	274.96	274.99	9941.0
2019-03-08 19:30:00	SPY	ETF	275.0	275.06	274.98	275.01	22173.0
2019-03-08 04:00:00	QQQ	ETF	170.78	170.78	170.45	170.53	5400.0
2019-03-08 04:30:00	QQQ	ETF	170.53	170.6	170.4	170.4	11795.0
2019-03-08 05:00:00	QQQ	ETF	170.45	170.47	170.24	170.25	27740.0
2019-03-08 05:30:00	QQQ	ETF	170.34	170.56	170.3	170.45	21595.0
2019-03-08 06:00:00	QQQ	ETF	170.45	170.53	170.37	170.53	6400.0
2019-03-08 06:30:00	QQQ	ETF	170.44	170.6	170.29	170.34	15961.0
2019-03-08 07:00:00	QQQ	ETF	170.39	170.5	170.36	170.47	37655.0
2019-03-08 07:30:00	QQQ	ETF	170.47	170.49	170.26	170.28	58776.0
2019-03-08 08:00:00	QQQ	ETF	170.27	170.91	170.24	170.44	113945.0
2019-03-08 08:30:00	QQQ	ETF	170.22	170.24	169.61	169.67	601522.0
2019-03-08 09:00:00	QQQ	ETF	169.63	169.63	169.25	169.54	298131.0
2019-03-08 09:30:00	QQQ	ETF	169.53	170.17	169.35	169.84	5858038.0
2019-03-08 10:00:00	QQQ	ETF	169.83	170.16	169.3375	170.07	3461178.0
2019-03-08 10:30:00	QQQ	ETF	170.07	170.6564	169.78	170.22	2689095.0
2019-03-08 11:00:00	QQQ	ETF	170.22	170.79	170.14	170.59	2781000.0
2019-03-08 11:30:00	QQQ	ETF	170.59	170.78	170.24	170.26	1603166.0
2019-03-08 12:00:00	QQQ	ETF	170.26	170.33	169.87	170.08	1615188.0
2019-03-08 12:30:00	QQQ	ETF	170.06	170.13	169.71	169.767	1197168.0

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

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