PREVIEW / etf_30min / 2018-05-09

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-05-09.parquet
  size:    465 KB
  rows:    16,017

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-05-09 04:00:00	SPY	ETF	267.65	267.9	267.29	267.82	16003.0
2018-05-09 04:30:00	SPY	ETF	267.78	268.3	267.78	268.3	6462.0
2018-05-09 05:00:00	SPY	ETF	268.31	268.33	268.19	268.19	7578.0
2018-05-09 05:30:00	SPY	ETF	268.19	268.36	268.12	268.24	8920.0
2018-05-09 06:00:00	SPY	ETF	268.29	268.32	268.0	268.06	36677.0
2018-05-09 06:30:00	SPY	ETF	268.05	268.12	267.97	268.1	21125.0
2018-05-09 07:00:00	SPY	ETF	268.06	268.18	267.99	268.18	65245.0
2018-05-09 07:30:00	SPY	ETF	268.18	268.18	267.82	267.82	48534.0
2018-05-09 08:00:00	SPY	ETF	267.85	268.16	267.25	267.85	164834.0
2018-05-09 08:30:00	SPY	ETF	267.88	267.94	267.75	267.76	168039.0
2018-05-09 09:00:00	SPY	ETF	267.76	267.76	267.61	267.64	298766.0
2018-05-09 09:30:00	SPY	ETF	267.68	268.06	267.37	267.635	5354185.0
2018-05-09 10:00:00	SPY	ETF	267.63	268.03	267.42	267.7	3170425.0
2018-05-09 10:30:00	SPY	ETF	267.7	267.9	267.12	267.18	3293578.0
2018-05-09 11:00:00	SPY	ETF	267.19	267.63	267.09	267.6	3072667.0
2018-05-09 11:30:00	SPY	ETF	267.6	267.8	267.51	267.73	1823501.0
2018-05-09 12:00:00	SPY	ETF	267.74	268.57	267.725	268.515	3478919.0
2018-05-09 12:30:00	SPY	ETF	268.5	269.21	268.44	269.04	3634960.0
2018-05-09 13:00:00	SPY	ETF	269.045	269.48	268.93	269.45	4063063.0
2018-05-09 13:30:00	SPY	ETF	269.455	269.68	269.435	269.63	2890559.0
2018-05-09 14:00:00	SPY	ETF	269.64	269.865	269.18	269.38	3164515.0
2018-05-09 14:30:00	SPY	ETF	269.36	269.81	269.36	269.62	2641263.0
2018-05-09 15:00:00	SPY	ETF	269.62	269.76	269.23	269.305	3553751.0
2018-05-09 15:30:00	SPY	ETF	269.31	269.49	269.02	269.48	11356069.0
2018-05-09 16:00:00	SPY	ETF	269.47	269.62	269.4115	269.53	5795549.0
2018-05-09 16:30:00	SPY	ETF	269.51	269.55	269.48	269.52	178788.0
2018-05-09 17:00:00	SPY	ETF	269.49	269.55	269.48	269.53	84724.0
2018-05-09 17:30:00	SPY	ETF	269.54	269.55	269.5	269.52	10873.0
2018-05-09 18:00:00	SPY	ETF	269.52	269.7	269.46	269.53	66760.0
2018-05-09 18:30:00	SPY	ETF	269.5	269.55	269.48	269.54	10871.0
2018-05-09 19:00:00	SPY	ETF	269.53	269.54	269.32	269.32	20009.0
2018-05-09 19:30:00	SPY	ETF	269.34	269.52	269.21	269.49	24425.0
2018-05-09 04:00:00	QQQ	ETF	166.38	166.43	166.32	166.43	8882.0
2018-05-09 04:30:00	QQQ	ETF	166.45	166.75	166.45	166.75	6307.0
2018-05-09 05:00:00	QQQ	ETF	166.76	166.76	166.67	166.68	7700.0
2018-05-09 05:30:00	QQQ	ETF	166.7	166.8	166.62	166.77	5584.0
2018-05-09 06:00:00	QQQ	ETF	166.73	166.73	166.55	166.56	4200.0
2018-05-09 06:30:00	QQQ	ETF	166.52	166.57	166.51	166.52	4946.0
2018-05-09 07:00:00	QQQ	ETF	166.53	166.7	166.5	166.7	21682.0
2018-05-09 07:30:00	QQQ	ETF	166.66	166.66	166.49	166.5	72007.0
2018-05-09 08:00:00	QQQ	ETF	166.55	166.65	166.46	166.46	35267.0
2018-05-09 08:30:00	QQQ	ETF	166.54	166.6	166.4	166.4497	49914.0
2018-05-09 09:00:00	QQQ	ETF	166.42	166.48	166.38	166.38	69529.0
2018-05-09 09:30:00	QQQ	ETF	166.39	166.68	166.05	166.12	2859990.0
2018-05-09 10:00:00	QQQ	ETF	166.13	166.57	165.99	166.26	1479070.0
2018-05-09 10:30:00	QQQ	ETF	166.29	166.51	165.8	165.9	1404351.0
2018-05-09 11:00:00	QQQ	ETF	165.91	166.33	165.78	166.24	1251298.0
2018-05-09 11:30:00	QQQ	ETF	166.2364	166.4728	166.17	166.46	723809.0
2018-05-09 12:00:00	QQQ	ETF	166.46	167.03	166.42	166.99	1408239.0
2018-05-09 12:30:00	QQQ	ETF	166.9958	167.37	166.9	167.2762	1670640.0

> showing 50 of 16,017 rows — these rows as CSV

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