PREVIEW / etf_30min / 2018-04-23

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-04-23.parquet
  size:    455 KB
  rows:    15,748

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-04-23 04:00:00	SPY	ETF	266.82	266.82	266.28	266.39	17408.0
2018-04-23 04:30:00	SPY	ETF	266.4	266.46	266.35	266.44	4272.0
2018-04-23 05:00:00	SPY	ETF	266.48	266.48	266.32	266.48	6155.0
2018-04-23 05:30:00	SPY	ETF	266.38	266.42	266.29	266.42	9466.0
2018-04-23 06:00:00	SPY	ETF	266.38	266.6	266.3	266.6	30418.0
2018-04-23 06:30:00	SPY	ETF	266.65	266.82	266.65	266.74	54447.0
2018-04-23 07:00:00	SPY	ETF	266.78	266.88	266.66	266.73	119746.0
2018-04-23 07:30:00	SPY	ETF	266.72	267.04	266.72	266.99	56592.0
2018-04-23 08:00:00	SPY	ETF	266.78	267.56	266.6	267.26	216596.0
2018-04-23 08:30:00	SPY	ETF	267.28	267.4	267.21	267.38	324402.0
2018-04-23 09:00:00	SPY	ETF	267.37	267.37	266.61	267.27	262875.0
2018-04-23 09:30:00	SPY	ETF	267.26	267.36	266.39	267.03	5392037.0
2018-04-23 10:00:00	SPY	ETF	267.04	267.23	266.55	266.91	3911741.0
2018-04-23 10:30:00	SPY	ETF	266.93	267.18	266.37	267.02	4215991.0
2018-04-23 11:00:00	SPY	ETF	267.02	267.89	266.905	267.78	3718001.0
2018-04-23 11:30:00	SPY	ETF	267.77	267.83	267.18	267.42	3743723.0
2018-04-23 12:00:00	SPY	ETF	267.42	267.55	266.95	266.99	2091335.0
2018-04-23 12:30:00	SPY	ETF	266.985	267.1483	266.56	266.79	3043414.0
2018-04-23 13:00:00	SPY	ETF	266.79	266.9	266.63	266.75	1738760.0
2018-04-23 13:30:00	SPY	ETF	266.75	267.08	266.52	266.92	3486969.0
2018-04-23 14:00:00	SPY	ETF	266.91	267.0	265.67	265.9099	5038908.0
2018-04-23 14:30:00	SPY	ETF	265.9	266.15	265.35	265.62	4379615.0
2018-04-23 15:00:00	SPY	ETF	265.62	266.3392	265.53	266.275	5176552.0
2018-04-23 15:30:00	SPY	ETF	266.28	266.62	266.05	266.58	8322371.0
2018-04-23 16:00:00	SPY	ETF	266.59	266.95	266.1416	266.64	7888702.0
2018-04-23 16:30:00	SPY	ETF	266.65	266.84	266.57	266.77	1318545.0
2018-04-23 17:00:00	SPY	ETF	266.78	266.83	266.72	266.72	26298.0
2018-04-23 17:30:00	SPY	ETF	266.71	266.75	266.71	266.72	12836.0
2018-04-23 18:00:00	SPY	ETF	266.74	266.95	266.74	266.83	29747.0
2018-04-23 18:30:00	SPY	ETF	266.83	266.93	266.74	266.86	8372.0
2018-04-23 19:00:00	SPY	ETF	266.86	266.93	266.83	266.83	3636.0
2018-04-23 19:30:00	SPY	ETF	266.89	267.22	266.89	267.12	39423.0
2018-04-23 04:00:00	QQQ	ETF	162.37	162.42	162.1	162.11	8472.0
2018-04-23 04:30:00	QQQ	ETF	162.15	162.27	162.11	162.2	4136.0
2018-04-23 05:00:00	QQQ	ETF	162.24	162.3	162.24	162.26	821.0
2018-04-23 05:30:00	QQQ	ETF	162.15	162.35	162.14	162.29	28949.0
2018-04-23 06:00:00	QQQ	ETF	162.29	162.43	162.23	162.43	14500.0
2018-04-23 06:30:00	QQQ	ETF	162.5	162.65	162.47	162.54	10535.0
2018-04-23 07:00:00	QQQ	ETF	162.55	162.66	162.53	162.53	22544.0
2018-04-23 07:30:00	QQQ	ETF	162.64	162.9	162.64	162.83	88974.0
2018-04-23 08:00:00	QQQ	ETF	162.6699	163.06	162.17	163.06	139104.0
2018-04-23 08:30:00	QQQ	ETF	163.06	163.18	162.75	163.08	78070.0
2018-04-23 09:00:00	QQQ	ETF	163.12	163.12	163.0	163.08	101893.0
2018-04-23 09:30:00	QQQ	ETF	163.08	163.17	162.03	162.57	3855155.0
2018-04-23 10:00:00	QQQ	ETF	162.57	162.939	162.27	162.81	1682349.0
2018-04-23 10:30:00	QQQ	ETF	162.82	163.32	162.42	163.19	1847368.0
2018-04-23 11:00:00	QQQ	ETF	163.19	163.73	163.07	163.63	2152084.0
2018-04-23 11:30:00	QQQ	ETF	163.61	163.655	163.12	163.29	1158649.0
2018-04-23 12:00:00	QQQ	ETF	163.31	163.37	162.691	162.81	994642.0
2018-04-23 12:30:00	QQQ	ETF	162.81	162.92	162.217	162.37	1514553.0

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

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