PREVIEW / etf_30min / 2019-01-30

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-01-30.parquet
  size:    510 KB
  rows:    17,694

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-30 04:00:00	SPY	ETF	264.4	264.41	263.97	264.22	15187.0
2019-01-30 04:30:00	SPY	ETF	264.23	264.39	264.19	264.22	10650.0
2019-01-30 05:00:00	SPY	ETF	264.3	264.35	264.12	264.24	20655.0
2019-01-30 05:30:00	SPY	ETF	264.18	264.32	264.09	264.3	20038.0
2019-01-30 06:00:00	SPY	ETF	264.26	264.4	264.26	264.29	23550.0
2019-01-30 06:30:00	SPY	ETF	264.31	264.5	264.24	264.47	12524.0
2019-01-30 07:00:00	SPY	ETF	264.47	264.72	264.44	264.65	51367.0
2019-01-30 07:30:00	SPY	ETF	264.69	265.02	264.61	264.77	148151.0
2019-01-30 08:00:00	SPY	ETF	264.26	264.91	263.7	264.52	196969.0
2019-01-30 08:30:00	SPY	ETF	264.54	264.9	263.4284	264.84	147297.0
2019-01-30 09:00:00	SPY	ETF	264.8	265.16	264.75	265.11	273242.0
2019-01-30 09:30:00	SPY	ETF	265.1	265.2475	264.47	264.56	7010085.0
2019-01-30 10:00:00	SPY	ETF	264.55	264.78	264.25	264.76	4521370.0
2019-01-30 10:30:00	SPY	ETF	264.76	265.08	264.56	264.87	3066143.0
2019-01-30 11:00:00	SPY	ETF	264.88	265.59	264.87	265.41	4913463.0
2019-01-30 11:30:00	SPY	ETF	265.4165	265.84	265.22	265.8171	3536598.0
2019-01-30 12:00:00	SPY	ETF	265.82	266.29	265.7619	266.02	4142242.0
2019-01-30 12:30:00	SPY	ETF	266.03	266.09	265.68	265.78	2489926.0
2019-01-30 13:00:00	SPY	ETF	265.77	265.92	265.53	265.58	1892781.0
2019-01-30 13:30:00	SPY	ETF	265.59	265.68	265.285	265.4525	2500598.0
2019-01-30 14:00:00	SPY	ETF	265.47	267.9701	264.97	267.47	15794558.0
2019-01-30 14:30:00	SPY	ETF	267.47	268.52	267.13	268.48	9935677.0
2019-01-30 15:00:00	SPY	ETF	268.49	268.49	267.3	267.435	7373149.0
2019-01-30 15:30:00	SPY	ETF	267.43	267.6	267.0	267.59	14886588.0
2019-01-30 16:00:00	SPY	ETF	267.59	267.9	267.09	267.89	6884259.0
2019-01-30 16:30:00	SPY	ETF	267.87	268.05	267.55	267.9	505750.0
2019-01-30 17:00:00	SPY	ETF	267.81	268.05	267.77	268.0	307421.0
2019-01-30 17:30:00	SPY	ETF	268.0	268.04	267.91	267.97	88677.0
2019-01-30 18:00:00	SPY	ETF	267.96	268.22	267.78	268.19	121003.0
2019-01-30 18:30:00	SPY	ETF	268.22	268.34	268.17	268.31	63569.0
2019-01-30 19:00:00	SPY	ETF	268.31	268.31	268.02	268.11	60752.0
2019-01-30 19:30:00	SPY	ETF	268.11	268.11	267.75	267.86	75950.0
2019-01-30 20:00:00	SPY	ETF	267.58	267.98	267.58	267.98	1000.0
2019-01-30 04:00:00	QQQ	ETF	162.73	162.79	162.67	162.79	12115.0
2019-01-30 04:30:00	QQQ	ETF	162.82	162.92	162.78	162.78	6080.0
2019-01-30 05:00:00	QQQ	ETF	162.8	162.85	162.66	162.75	8812.0
2019-01-30 05:30:00	QQQ	ETF	162.75	162.85	162.66	162.82	11000.0
2019-01-30 06:00:00	QQQ	ETF	162.79	162.9	162.76	162.76	3410.0
2019-01-30 06:30:00	QQQ	ETF	162.73	162.93	162.7	162.91	5697.0
2019-01-30 07:00:00	QQQ	ETF	162.95	163.12	162.92	163.03	34480.0
2019-01-30 07:30:00	QQQ	ETF	163.03	163.23	162.95	163.09	66737.0
2019-01-30 08:00:00	QQQ	ETF	161.57	163.19	161.57	162.8	115450.0
2019-01-30 08:30:00	QQQ	ETF	162.84	163.19	162.79	163.11	157302.0
2019-01-30 09:00:00	QQQ	ETF	163.07	163.45	163.07	163.4	178064.0
2019-01-30 09:30:00	QQQ	ETF	163.39	163.91	163.19	163.29	3798374.0
2019-01-30 10:00:00	QQQ	ETF	163.27	163.46	162.89	163.38	1890568.0
2019-01-30 10:30:00	QQQ	ETF	163.38	163.54	163.1615	163.26	1102042.0
2019-01-30 11:00:00	QQQ	ETF	163.28	163.67	163.26	163.445	1375340.0
2019-01-30 11:30:00	QQQ	ETF	163.45	163.81	163.31	163.81	734493.0
2019-01-30 12:00:00	QQQ	ETF	163.81	164.51	163.78	164.29	2664694.0

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

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