PREVIEW / etf_30min / 2019-07-16

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-07-16.parquet
  size:    497 KB
  rows:    17,465

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-07-16 04:00:00	SPY	ETF	300.82	300.82	300.82	300.82	350.0
2019-07-16 04:30:00	SPY	ETF	300.82	300.9	300.82	300.9	339.0
2019-07-16 05:00:00	SPY	ETF	300.94	300.97	300.74	300.74	2014.0
2019-07-16 05:30:00	SPY	ETF	300.63	300.65	300.61	300.64	1270.0
2019-07-16 06:00:00	SPY	ETF	300.84	300.84	300.82	300.84	3128.0
2019-07-16 06:30:00	SPY	ETF	300.85	300.86	300.6	300.65	21739.0
2019-07-16 07:00:00	SPY	ETF	300.7	300.89	300.69	300.84	45784.0
2019-07-16 07:30:00	SPY	ETF	300.83	301.06	300.83	301.0	99533.0
2019-07-16 08:00:00	SPY	ETF	300.71	301.16	300.67	300.98	126345.0
2019-07-16 08:30:00	SPY	ETF	300.98	301.08	300.75	300.77	327651.0
2019-07-16 09:00:00	SPY	ETF	300.76	300.8591	300.65	300.65	289093.0
2019-07-16 09:30:00	SPY	ETF	300.65	300.775	300.4	300.66	2613504.0
2019-07-16 10:00:00	SPY	ETF	300.655	300.71	300.4	300.69	1962045.0
2019-07-16 10:30:00	SPY	ETF	300.69	300.88	300.53	300.71	2292343.0
2019-07-16 11:00:00	SPY	ETF	300.72	300.75	300.34	300.41	2265023.0
2019-07-16 11:30:00	SPY	ETF	300.41	300.53	300.045	300.075	2739941.0
2019-07-16 12:00:00	SPY	ETF	300.07	300.17	299.44	299.7136	3904701.0
2019-07-16 12:30:00	SPY	ETF	299.72	300.05	299.64	299.9	2154060.0
2019-07-16 13:00:00	SPY	ETF	299.9	300.32	299.895	300.16	2156690.0
2019-07-16 13:30:00	SPY	ETF	300.1567	300.21	299.55	299.59	2257193.0
2019-07-16 14:00:00	SPY	ETF	299.59	299.83	299.47	299.64	1553807.0
2019-07-16 14:30:00	SPY	ETF	299.63	299.96	299.45	299.8	2170730.0
2019-07-16 15:00:00	SPY	ETF	299.795	300.12	299.712	299.8815	2925929.0
2019-07-16 15:30:00	SPY	ETF	299.88	300.155	299.62	299.74	6095814.0
2019-07-16 16:00:00	SPY	ETF	299.74	299.95	299.65	299.74	3419546.0
2019-07-16 16:30:00	SPY	ETF	299.73	299.7463	299.53	299.58	373811.0
2019-07-16 17:00:00	SPY	ETF	299.61	299.64	299.5	299.6	52440.0
2019-07-16 17:30:00	SPY	ETF	299.6	299.71	299.6	299.62	27249.0
2019-07-16 18:00:00	SPY	ETF	299.61	299.71	299.43	299.55	52376.0
2019-07-16 18:30:00	SPY	ETF	299.6	299.75	299.57	299.74	16566.0
2019-07-16 19:00:00	SPY	ETF	299.66	299.66	299.61	299.61	11635.0
2019-07-16 19:30:00	SPY	ETF	299.62	299.7	299.61	299.64	15324.0
2019-07-16 04:00:00	QQQ	ETF	194.24	194.32	194.24	194.3	8200.0
2019-07-16 04:30:00	QQQ	ETF	194.24	194.29	194.24	194.29	600.0
2019-07-16 05:00:00	QQQ	ETF	194.3	194.3	194.16	194.16	2040.0
2019-07-16 05:30:00	QQQ	ETF	194.1	194.14	194.06	194.1	3719.0
2019-07-16 06:00:00	QQQ	ETF	194.13	194.21	194.13	194.2	1220.0
2019-07-16 06:30:00	QQQ	ETF	194.06	194.12	194.01	194.09	5271.0
2019-07-16 07:00:00	QQQ	ETF	194.12	194.25	194.12	194.21	42055.0
2019-07-16 07:30:00	QQQ	ETF	194.22	194.34	194.07	194.21	87161.0
2019-07-16 08:00:00	QQQ	ETF	194.16	194.32	194.14	194.21	66027.0
2019-07-16 08:30:00	QQQ	ETF	194.21	194.23	194.01	194.03	114033.0
2019-07-16 09:00:00	QQQ	ETF	194.01	194.09	193.85	193.87	31055.0
2019-07-16 09:30:00	QQQ	ETF	193.86	194.09	193.71	194.0431	2164954.0
2019-07-16 10:00:00	QQQ	ETF	194.04	194.0499	193.61	193.85	997588.0
2019-07-16 10:30:00	QQQ	ETF	193.85	194.02	193.72	193.87	682044.0
2019-07-16 11:00:00	QQQ	ETF	193.87	193.91	193.5	193.5966	806774.0
2019-07-16 11:30:00	QQQ	ETF	193.59	193.685	193.4	193.44	562421.0
2019-07-16 12:00:00	QQQ	ETF	193.43	193.51	192.56	192.89	2524602.0
2019-07-16 12:30:00	QQQ	ETF	192.9	193.24	192.855	193.22	1026307.0

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

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