PREVIEW / etf_30min / 2019-02-04

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-02-04.parquet
  size:    496 KB
  rows:    17,146

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-02-04 04:00:00	SPY	ETF	269.9	270.18	269.89	270.18	5707.0
2019-02-04 04:30:00	SPY	ETF	270.23	270.3	270.14	270.3	2900.0
2019-02-04 05:00:00	SPY	ETF	270.34	270.37	270.2	270.2	7725.0
2019-02-04 05:30:00	SPY	ETF	270.45	270.52	270.39	270.39	3841.0
2019-02-04 06:00:00	SPY	ETF	270.2	270.34	270.15	270.22	8437.0
2019-02-04 06:30:00	SPY	ETF	270.16	270.23	270.12	270.16	8907.0
2019-02-04 07:00:00	SPY	ETF	270.12	270.45	270.12	270.45	13275.0
2019-02-04 07:30:00	SPY	ETF	270.4	270.45	270.28	270.37	44557.0
2019-02-04 08:00:00	SPY	ETF	270.39	270.4	269.92	270.09	54111.0
2019-02-04 08:30:00	SPY	ETF	270.03	270.07	269.86	270.06	63668.0
2019-02-04 09:00:00	SPY	ETF	270.03	270.14	269.94	270.12	147478.0
2019-02-04 09:30:00	SPY	ETF	270.11	270.32	269.6285	269.995	4656417.0
2019-02-04 10:00:00	SPY	ETF	269.99	270.12	269.36	269.66	4695082.0
2019-02-04 10:30:00	SPY	ETF	269.65	270.25	269.63	270.17	2258001.0
2019-02-04 11:00:00	SPY	ETF	270.17	270.64	270.15	270.64	3511042.0
2019-02-04 11:30:00	SPY	ETF	270.63	270.96	270.5	270.905	3549965.0
2019-02-04 12:00:00	SPY	ETF	270.9	271.02	270.83	270.88	2049889.0
2019-02-04 12:30:00	SPY	ETF	270.87	271.01	270.76	270.92	1657192.0
2019-02-04 13:00:00	SPY	ETF	270.93	271.14	270.9	270.975	2258687.0
2019-02-04 13:30:00	SPY	ETF	270.968	271.43	270.945	271.39	2748924.0
2019-02-04 14:00:00	SPY	ETF	271.39	271.56	271.36	271.425	3546398.0
2019-02-04 14:30:00	SPY	ETF	271.43	271.49	271.21	271.4192	2609295.0
2019-02-04 15:00:00	SPY	ETF	271.41	271.53	271.23	271.37	4103286.0
2019-02-04 15:30:00	SPY	ETF	271.36	272.02	271.2	272.0	11879883.0
2019-02-04 16:00:00	SPY	ETF	272.0	272.13	270.4	271.83	7444314.0
2019-02-04 16:30:00	SPY	ETF	271.83	271.96	270.1811	271.81	505796.0
2019-02-04 17:00:00	SPY	ETF	271.79	271.96	271.63	271.63	72844.0
2019-02-04 17:30:00	SPY	ETF	271.64	271.71	271.58	271.58	35818.0
2019-02-04 18:00:00	SPY	ETF	271.66	271.84	271.63	271.77	33125.0
2019-02-04 18:30:00	SPY	ETF	271.77	271.77	271.53	271.54	23580.0
2019-02-04 19:00:00	SPY	ETF	271.62	271.82	271.62	271.82	10403.0
2019-02-04 19:30:00	SPY	ETF	271.8	271.83	271.35	271.44	38420.0
2019-02-04 04:00:00	QQQ	ETF	167.3	167.52	167.3	167.5	3899.0
2019-02-04 04:30:00	QQQ	ETF	167.51	167.52	167.45	167.45	1323.0
2019-02-04 05:00:00	QQQ	ETF	167.58	167.62	167.53	167.53	36500.0
2019-02-04 05:30:00	QQQ	ETF	167.53	167.7	167.48	167.5	27820.0
2019-02-04 06:00:00	QQQ	ETF	167.48	167.52	167.47	167.5	2500.0
2019-02-04 06:30:00	QQQ	ETF	167.48	167.55	167.47	167.53	1957.0
2019-02-04 07:00:00	QQQ	ETF	167.53	167.66	167.53	167.63	14277.0
2019-02-04 07:30:00	QQQ	ETF	167.63	167.65	167.55	167.63	8915.0
2019-02-04 08:00:00	QQQ	ETF	167.4999	167.65	167.34	167.37	48297.0
2019-02-04 08:30:00	QQQ	ETF	167.36	167.36	167.23	167.36	57799.0
2019-02-04 09:00:00	QQQ	ETF	167.34	167.49	167.32	167.49	42252.0
2019-02-04 09:30:00	QQQ	ETF	167.5	168.22	167.33	168.0958	3263785.0
2019-02-04 10:00:00	QQQ	ETF	168.1	168.56	167.78	168.26	2731044.0
2019-02-04 10:30:00	QQQ	ETF	168.25	168.84	168.24	168.6601	1545245.0
2019-02-04 11:00:00	QQQ	ETF	168.7	169.115	168.69	168.97	1759106.0
2019-02-04 11:30:00	QQQ	ETF	168.9767	169.16	168.79	169.065	1192476.0
2019-02-04 12:00:00	QQQ	ETF	169.07	169.13	168.93	168.95	730000.0
2019-02-04 12:30:00	QQQ	ETF	168.95	169.1	168.9115	169.0368	644193.0

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

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