PREVIEW / etf_30min / 2015-01-02

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-01-02.parquet
  size:    373 KB
  rows:    12,524

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
2015-01-02 04:00:00	SPY	ETF	206.25	206.38	206.17	206.33	51135.0
2015-01-02 04:30:00	SPY	ETF	206.2	206.27	206.2	206.25	25223.0
2015-01-02 05:00:00	SPY	ETF	206.32	206.34	206.11	206.24	3512.0
2015-01-02 05:30:00	SPY	ETF	206.22	206.39	206.22	206.39	9934.0
2015-01-02 06:00:00	SPY	ETF	206.4	206.4	206.17	206.17	13524.0
2015-01-02 06:30:00	SPY	ETF	206.16	206.29	206.09	206.14	46824.0
2015-01-02 07:00:00	SPY	ETF	206.24	206.3	206.18	206.18	84538.0
2015-01-02 07:30:00	SPY	ETF	206.18	206.43	206.18	206.36	130888.0
2015-01-02 08:00:00	SPY	ETF	206.36	206.42	206.18	206.4	207537.0
2015-01-02 08:30:00	SPY	ETF	206.4	206.45	205.5	206.43	150461.0
2015-01-02 09:00:00	SPY	ETF	206.44	206.67	205.5	206.37	1517484.0
2015-01-02 09:30:00	SPY	ETF	206.38	206.88	206.29	206.51	13700055.0
2015-01-02 10:00:00	SPY	ETF	206.5	206.56	205.79	206.05	10753477.0
2015-01-02 10:30:00	SPY	ETF	206.05	206.06	204.83	205.23	13371986.0
2015-01-02 11:00:00	SPY	ETF	205.24	205.31	204.47	204.98	9578496.0
2015-01-02 11:30:00	SPY	ETF	204.98	205.15	204.66	204.96	5616889.0
2015-01-02 12:00:00	SPY	ETF	204.95	205.4	204.875	205.11	7338908.0
2015-01-02 12:30:00	SPY	ETF	205.11	205.31	204.75	204.825	4617834.0
2015-01-02 13:00:00	SPY	ETF	204.83	205.5299	204.385	204.44	3893168.0
2015-01-02 13:30:00	SPY	ETF	204.44	204.79	204.18	204.595	5336794.0
2015-01-02 14:00:00	SPY	ETF	204.59	205.19	204.55	204.94	5797415.0
2015-01-02 14:30:00	SPY	ETF	204.95	205.33	204.84	205.0561	5119437.0
2015-01-02 15:00:00	SPY	ETF	205.06	205.21	204.63	205.14	5568941.0
2015-01-02 15:30:00	SPY	ETF	205.135	205.88	205.09	205.41	13458850.0
2015-01-02 16:00:00	SPY	ETF	205.38	206.9	204.88	205.01	9746023.0
2015-01-02 16:30:00	SPY	ETF	205.01	205.4518	205.01	205.05	3198517.0
2015-01-02 17:00:00	SPY	ETF	205.04	205.04	204.93	204.98	81807.0
2015-01-02 17:30:00	SPY	ETF	204.93	205.04	204.93	205.04	27586.0
2015-01-02 18:00:00	SPY	ETF	205.03	205.04	204.95	205.04	9508.0
2015-01-02 18:30:00	SPY	ETF	205.04	205.1	205.04	205.05	7757.0
2015-01-02 19:00:00	SPY	ETF	205.02	205.08	205.02	205.06	10973.0
2015-01-02 19:30:00	SPY	ETF	205.06	205.12	205.06	205.11	12864.0
2015-01-02 04:30:00	QQQ	ETF	103.66	103.66	103.61	103.61	1800.0
2015-01-02 06:30:00	QQQ	ETF	103.59	103.59	103.55	103.55	5200.0
2015-01-02 07:00:00	QQQ	ETF	103.63	103.63	103.62	103.62	1400.0
2015-01-02 07:30:00	QQQ	ETF	103.63	103.73	103.61	103.71	6632.0
2015-01-02 08:00:00	QQQ	ETF	103.72	103.87	103.6	103.66	52566.0
2015-01-02 08:30:00	QQQ	ETF	103.66	103.76	103.64	103.76	72637.0
2015-01-02 09:00:00	QQQ	ETF	103.76	103.85	103.7	103.75	248798.0
2015-01-02 09:30:00	QQQ	ETF	103.75	104.2	103.7	103.86	3879562.0
2015-01-02 10:00:00	QQQ	ETF	103.84	103.88	103.46	103.56	3074947.0
2015-01-02 10:30:00	QQQ	ETF	103.57	103.57	102.67	102.97	3893225.0
2015-01-02 11:00:00	QQQ	ETF	102.97	102.99	102.44	102.7	3075136.0
2015-01-02 11:30:00	QQQ	ETF	102.7	102.88	102.56	102.85	1519241.0
2015-01-02 12:00:00	QQQ	ETF	102.84	103.05	102.8	102.86	1476252.0
2015-01-02 12:30:00	QQQ	ETF	102.875	102.968	102.69	102.73	874008.0
2015-01-02 13:00:00	QQQ	ETF	102.74	102.81	102.565	102.6	910570.0
2015-01-02 13:30:00	QQQ	ETF	102.59	102.81	102.454	102.72	1855815.0
2015-01-02 14:00:00	QQQ	ETF	102.7	103.01	102.6901	102.86	1003241.0
2015-01-02 14:30:00	QQQ	ETF	102.86	103.03	102.8161	102.88	1131870.0

> showing 50 of 12,524 rows — these rows as CSV

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