PREVIEW / etf_30min / 2018-05-02

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-05-02.parquet
  size:    454 KB
  rows:    15,753

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-05-02 04:00:00	SPY	ETF	265.2	265.44	265.2	265.34	3835.0
2018-05-02 04:30:00	SPY	ETF	265.35	265.4	265.3	265.33	5300.0
2018-05-02 05:00:00	SPY	ETF	265.45	265.65	265.45	265.57	2842.0
2018-05-02 05:30:00	SPY	ETF	265.59	265.59	265.5	265.5	1900.0
2018-05-02 06:00:00	SPY	ETF	265.41	265.41	264.97	265.05	6420.0
2018-05-02 06:30:00	SPY	ETF	265.02	265.42	265.02	265.36	13827.0
2018-05-02 07:00:00	SPY	ETF	265.33	265.58	265.27	265.27	52357.0
2018-05-02 07:30:00	SPY	ETF	265.33	265.33	265.07	265.07	57528.0
2018-05-02 08:00:00	SPY	ETF	265.2299	265.4	264.83	265.04	70714.0
2018-05-02 08:30:00	SPY	ETF	265.04	265.13	264.68	264.84	222127.0
2018-05-02 09:00:00	SPY	ETF	264.85	264.92	264.62	264.8	263937.0
2018-05-02 09:30:00	SPY	ETF	264.76	264.94	264.09	264.14	5822333.0
2018-05-02 10:00:00	SPY	ETF	264.15	264.765	264.06	264.26	5740527.0
2018-05-02 10:30:00	SPY	ETF	264.27	264.66	264.1	264.49	3536651.0
2018-05-02 11:00:00	SPY	ETF	264.49	264.9	264.25	264.63	4261860.0
2018-05-02 11:30:00	SPY	ETF	264.64	264.659	263.87	264.18	6156704.0
2018-05-02 12:00:00	SPY	ETF	264.17	264.66	264.01	264.53	2218038.0
2018-05-02 12:30:00	SPY	ETF	264.52	264.61	264.25	264.525	1939347.0
2018-05-02 13:00:00	SPY	ETF	264.51	264.99	264.51	264.87	1739800.0
2018-05-02 13:30:00	SPY	ETF	264.87	264.94	264.68	264.79	1559007.0
2018-05-02 14:00:00	SPY	ETF	264.82	265.68	264.71	265.21	7377935.0
2018-05-02 14:30:00	SPY	ETF	265.22	265.42	264.39	264.54	4034269.0
2018-05-02 15:00:00	SPY	ETF	264.55	264.8363	263.505	263.78	5896584.0
2018-05-02 15:30:00	SPY	ETF	263.7808	263.84	262.76	263.2	19014233.0
2018-05-02 16:00:00	SPY	ETF	263.2	263.2	262.58	262.77	13127246.0
2018-05-02 16:30:00	SPY	ETF	262.73	262.82	262.35	262.48	657034.0
2018-05-02 17:00:00	SPY	ETF	262.46	263.2	262.44	262.53	210117.0
2018-05-02 17:30:00	SPY	ETF	262.52	263.2	262.47	262.55	73918.0
2018-05-02 18:00:00	SPY	ETF	262.56	263.17	262.42	262.86	730846.0
2018-05-02 18:30:00	SPY	ETF	262.85	262.92	262.8	262.9	24571.0
2018-05-02 19:00:00	SPY	ETF	262.84	262.86	262.71	262.83	24659.0
2018-05-02 19:30:00	SPY	ETF	262.83	262.84	262.67	262.71	18696.0
2018-05-02 04:00:00	QQQ	ETF	163.61	163.61	163.44	163.5	1600.0
2018-05-02 04:30:00	QQQ	ETF	163.49	163.49	163.4	163.49	3175.0
2018-05-02 05:00:00	QQQ	ETF	163.46	163.69	163.46	163.63	7525.0
2018-05-02 05:30:00	QQQ	ETF	163.68	163.75	163.63	163.63	16353.0
2018-05-02 06:00:00	QQQ	ETF	163.64	163.64	163.18	163.22	5000.0
2018-05-02 06:30:00	QQQ	ETF	163.32	163.45	163.31	163.42	4800.0
2018-05-02 07:00:00	QQQ	ETF	163.4	163.62	163.34	163.39	27384.0
2018-05-02 07:30:00	QQQ	ETF	163.4	163.41	163.23	163.24	86665.0
2018-05-02 08:00:00	QQQ	ETF	163.3899	163.46	163.19	163.2	122155.0
2018-05-02 08:30:00	QQQ	ETF	163.23	163.23	162.84	163.1	136720.0
2018-05-02 09:00:00	QQQ	ETF	163.11	163.2	162.99	163.1	171258.0
2018-05-02 09:30:00	QQQ	ETF	163.1	163.11	162.23	162.68	3822203.0
2018-05-02 10:00:00	QQQ	ETF	162.7	163.29	162.585	162.7821	2924431.0
2018-05-02 10:30:00	QQQ	ETF	162.78	163.07	162.55	162.66	1507000.0
2018-05-02 11:00:00	QQQ	ETF	162.69	163.045	162.4639	162.79	1115163.0
2018-05-02 11:30:00	QQQ	ETF	162.78	162.82	161.89	162.245	2162686.0
2018-05-02 12:00:00	QQQ	ETF	162.24	162.59	162.08	162.54	1194729.0
2018-05-02 12:30:00	QQQ	ETF	162.53	162.63	162.32	162.51	1614740.0

> showing 50 of 15,753 rows — these rows as CSV

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