PREVIEW / etf_30min / 2019-01-17

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-01-17.parquet
  size:    498 KB
  rows:    17,232

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-01-17 04:00:00	SPY	ETF	259.76	259.91	259.61	259.91	25955.0
2019-01-17 04:30:00	SPY	ETF	259.72	259.76	259.31	259.49	11459.0
2019-01-17 05:00:00	SPY	ETF	259.6	259.97	259.6	259.91	28161.0
2019-01-17 05:30:00	SPY	ETF	259.91	260.02	259.76	260.02	38030.0
2019-01-17 06:00:00	SPY	ETF	260.07	260.07	259.94	260.02	5180.0
2019-01-17 06:30:00	SPY	ETF	260.04	260.18	259.79	259.93	61075.0
2019-01-17 07:00:00	SPY	ETF	260.0	260.0	259.5	259.67	117230.0
2019-01-17 07:30:00	SPY	ETF	259.68	259.85	259.62	259.72	86057.0
2019-01-17 08:00:00	SPY	ETF	259.82	259.98	259.1	259.82	251572.0
2019-01-17 08:30:00	SPY	ETF	259.85	260.32	259.85	260.06	352063.0
2019-01-17 09:00:00	SPY	ETF	260.04	260.1744	259.9	260.0	187302.0
2019-01-17 09:30:00	SPY	ETF	260.01	261.2	259.96	261.04	9261709.0
2019-01-17 10:00:00	SPY	ETF	261.03	261.27	260.54	261.12	4726929.0
2019-01-17 10:30:00	SPY	ETF	261.11	261.23	260.77	261.11	3449846.0
2019-01-17 11:00:00	SPY	ETF	261.11	261.55	261.1	261.45	3491772.0
2019-01-17 11:30:00	SPY	ETF	261.45	261.7	261.33	261.505	3530005.0
2019-01-17 12:00:00	SPY	ETF	261.51	261.7	261.35	261.58	2061073.0
2019-01-17 12:30:00	SPY	ETF	261.5815	261.7	261.17	261.28	3029661.0
2019-01-17 13:00:00	SPY	ETF	261.28	261.96	261.26	261.85	3189779.0
2019-01-17 13:30:00	SPY	ETF	261.86	261.94	261.57	261.86	2211974.0
2019-01-17 14:00:00	SPY	ETF	261.86	261.91	261.53	261.64	3170783.0
2019-01-17 14:30:00	SPY	ETF	261.64	263.92	261.51	262.61	20345866.0
2019-01-17 15:00:00	SPY	ETF	262.62	262.72	261.94	262.7	9564997.0
2019-01-17 15:30:00	SPY	ETF	262.695	263.06	262.37	262.98	12047262.0
2019-01-17 16:00:00	SPY	ETF	262.97	263.27	262.62	262.84	10843067.0
2019-01-17 16:30:00	SPY	ETF	262.85	263.3	262.84	263.15	1504839.0
2019-01-17 17:00:00	SPY	ETF	263.13	263.18	263.09	263.16	32825.0
2019-01-17 17:30:00	SPY	ETF	263.17	263.2	263.02	263.09	89897.0
2019-01-17 18:00:00	SPY	ETF	263.02	263.07	262.84	262.84	998720.0
2019-01-17 18:30:00	SPY	ETF	262.84	262.85	262.72	262.81	29377.0
2019-01-17 19:00:00	SPY	ETF	262.78	263.5	262.71	263.5	55849.0
2019-01-17 19:30:00	SPY	ETF	263.45	263.74	263.23	263.3	97825.0
2019-01-17 04:00:00	QQQ	ETF	161.59	161.59	161.29	161.45	12722.0
2019-01-17 04:30:00	QQQ	ETF	161.4	161.4	161.11	161.19	13556.0
2019-01-17 05:00:00	QQQ	ETF	161.35	161.48	161.26	161.44	6105.0
2019-01-17 05:30:00	QQQ	ETF	161.44	161.48	161.34	161.46	17300.0
2019-01-17 06:00:00	QQQ	ETF	161.5	161.52	161.45	161.47	6057.0
2019-01-17 06:30:00	QQQ	ETF	161.61	161.61	161.42	161.45	4734.0
2019-01-17 07:00:00	QQQ	ETF	161.51	161.59	161.27	161.46	82218.0
2019-01-17 07:30:00	QQQ	ETF	161.48	161.59	161.44	161.53	13054.0
2019-01-17 08:00:00	QQQ	ETF	161.54	162.4	160.87	161.68	251636.0
2019-01-17 08:30:00	QQQ	ETF	161.75	162.1	161.75	161.8701	132304.0
2019-01-17 09:00:00	QQQ	ETF	161.87	162.03	161.8	161.86	86417.0
2019-01-17 09:30:00	QQQ	ETF	161.84	162.7797	161.57	162.65	3529834.0
2019-01-17 10:00:00	QQQ	ETF	162.6566	162.83	162.24	162.58	2268954.0
2019-01-17 10:30:00	QQQ	ETF	162.5747	162.64	162.28	162.57	1116624.0
2019-01-17 11:00:00	QQQ	ETF	162.56	162.86	162.56	162.715	1284077.0
2019-01-17 11:30:00	QQQ	ETF	162.72	162.86	162.52	162.65	1075037.0
2019-01-17 12:00:00	QQQ	ETF	162.66	162.82	162.56	162.7	620960.0
2019-01-17 12:30:00	QQQ	ETF	162.71	162.8135	162.45	162.5	1048039.0

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

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