PREVIEW / etf_30min / 2018-06-26

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-06-26.parquet
  size:    469 KB
  rows:    16,274

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-06-26 04:00:00	SPY	ETF	271.0	271.33	271.0	271.33	5920.0
2018-06-26 04:30:00	SPY	ETF	271.43	271.43	271.15	271.28	5105.0
2018-06-26 05:00:00	SPY	ETF	271.35	271.35	271.1	271.33	4670.0
2018-06-26 05:30:00	SPY	ETF	271.15	271.2	271.1	271.1	3000.0
2018-06-26 06:00:00	SPY	ETF	271.12	271.12	270.56	270.56	31222.0
2018-06-26 06:30:00	SPY	ETF	270.7	271.0	270.6	270.96	49398.0
2018-06-26 07:00:00	SPY	ETF	271.0	271.09	270.87	270.9	110116.0
2018-06-26 07:30:00	SPY	ETF	270.93	270.96	270.76	270.96	140085.0
2018-06-26 08:00:00	SPY	ETF	270.96	271.69	270.78	271.28	135518.0
2018-06-26 08:30:00	SPY	ETF	271.26	271.56	271.25	271.49	180385.0
2018-06-26 09:00:00	SPY	ETF	271.45	271.65	271.29	271.65	274852.0
2018-06-26 09:30:00	SPY	ETF	271.64	271.85	270.91	271.53	7814716.0
2018-06-26 10:00:00	SPY	ETF	271.5362	272.09	271.32	271.33	4763876.0
2018-06-26 10:30:00	SPY	ETF	271.33	271.55	270.79	271.3	4322293.0
2018-06-26 11:00:00	SPY	ETF	271.29	271.69	271.1699	271.44	3210437.0
2018-06-26 11:30:00	SPY	ETF	271.44	271.73	271.29	271.68	3018822.0
2018-06-26 12:00:00	SPY	ETF	271.67	272.17	271.67	271.88	3802271.0
2018-06-26 12:30:00	SPY	ETF	271.89	272.2	271.728	272.03	3046868.0
2018-06-26 13:00:00	SPY	ETF	272.03	272.55	271.96	272.43	3337484.0
2018-06-26 13:30:00	SPY	ETF	272.43	272.56	272.23	272.355	2814767.0
2018-06-26 14:00:00	SPY	ETF	272.36	272.46	272.1	272.1699	2699764.0
2018-06-26 14:30:00	SPY	ETF	272.165	272.52	272.11	272.2385	3019636.0
2018-06-26 15:00:00	SPY	ETF	272.22	272.29	271.78	271.82	4172952.0
2018-06-26 15:30:00	SPY	ETF	271.82	272.3	271.38	271.55	14559511.0
2018-06-26 16:00:00	SPY	ETF	271.55	271.96	271.55	271.94	4130723.0
2018-06-26 16:30:00	SPY	ETF	271.93	271.93	271.48	271.54	346094.0
2018-06-26 17:00:00	SPY	ETF	271.58	271.71	271.55	271.69	50542.0
2018-06-26 17:30:00	SPY	ETF	271.7	271.72	271.6	271.69	40954.0
2018-06-26 18:00:00	SPY	ETF	271.69	271.92	271.69	271.76	58756.0
2018-06-26 18:30:00	SPY	ETF	271.8	271.87	271.78	271.84	22298.0
2018-06-26 19:00:00	SPY	ETF	271.83	271.91	271.57	271.57	36478.0
2018-06-26 19:30:00	SPY	ETF	271.91	272.02	271.87	271.96	17203.0
2018-06-26 04:00:00	QQQ	ETF	171.37	171.72	171.36	171.68	26973.0
2018-06-26 04:30:00	QQQ	ETF	171.72	171.81	171.67	171.74	13780.0
2018-06-26 05:00:00	QQQ	ETF	171.89	171.97	171.79	171.97	8100.0
2018-06-26 05:30:00	QQQ	ETF	171.86	172.0	171.62	171.74	35587.0
2018-06-26 06:00:00	QQQ	ETF	171.77	171.79	171.42	171.49	31995.0
2018-06-26 06:30:00	QQQ	ETF	171.52	171.94	171.44	171.92	41251.0
2018-06-26 07:00:00	QQQ	ETF	171.88	171.93	171.7	171.7	90814.0
2018-06-26 07:30:00	QQQ	ETF	171.68	171.76	171.58	171.75	37488.0
2018-06-26 08:00:00	QQQ	ETF	171.75	172.08	171.59	172.05	137528.0
2018-06-26 08:30:00	QQQ	ETF	172.02	172.16	171.94	172.0	230861.0
2018-06-26 09:00:00	QQQ	ETF	171.9699	172.05	171.86	171.98	168054.0
2018-06-26 09:30:00	QQQ	ETF	171.99	172.5534	171.38	172.28	4904950.0
2018-06-26 10:00:00	QQQ	ETF	172.285	172.64	171.94	171.94	2678283.0
2018-06-26 10:30:00	QQQ	ETF	171.94	172.09	171.37	171.79	2237938.0
2018-06-26 11:00:00	QQQ	ETF	171.78	172.15	171.67	171.77	1402419.0
2018-06-26 11:30:00	QQQ	ETF	171.76	172.065	171.63	172.05	1390771.0
2018-06-26 12:00:00	QQQ	ETF	172.05	172.57	172.03	172.41	2001032.0
2018-06-26 12:30:00	QQQ	ETF	172.42	172.68	172.23	172.57	1233973.0

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

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