PREVIEW / etf_30min / 2018-02-07

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-02-07.parquet
  size:    512 KB
  rows:    17,725

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-02-07 04:00:00	SPY	ETF	266.94	266.96	266.38	266.81	52156.0
2018-02-07 04:30:00	SPY	ETF	266.9	267.2	266.5	266.61	11688.0
2018-02-07 05:00:00	SPY	ETF	266.7	267.06	266.65	266.65	18065.0
2018-02-07 05:30:00	SPY	ETF	266.8	266.94	266.42	266.58	17118.0
2018-02-07 06:00:00	SPY	ETF	266.42	266.92	266.32	266.85	19850.0
2018-02-07 06:30:00	SPY	ETF	266.87	268.16	266.87	268.0	122607.0
2018-02-07 07:00:00	SPY	ETF	268.17	268.35	267.81	268.1	394516.0
2018-02-07 07:30:00	SPY	ETF	268.09	268.49	267.7	268.06	319712.0
2018-02-07 08:00:00	SPY	ETF	267.92	268.54	265.92	268.0	335642.0
2018-02-07 08:30:00	SPY	ETF	267.97	268.2	267.44	267.97	424648.0
2018-02-07 09:00:00	SPY	ETF	267.92	268.6	267.72	268.49	1024851.0
2018-02-07 09:30:00	SPY	ETF	268.5	270.4	267.88	270.06	17062344.0
2018-02-07 10:00:00	SPY	ETF	270.06	271.3	269.65	270.415	13920569.0
2018-02-07 10:30:00	SPY	ETF	270.41	271.28	269.94	271.14	7321092.0
2018-02-07 11:00:00	SPY	ETF	271.125	272.36	271.01	271.32	9501897.0
2018-02-07 11:30:00	SPY	ETF	271.32	271.69	270.74	271.62	6664450.0
2018-02-07 12:00:00	SPY	ETF	271.63	271.78	270.83	271.3	11478658.0
2018-02-07 12:30:00	SPY	ETF	271.3	271.38	270.065	270.19	8278075.0
2018-02-07 13:00:00	SPY	ETF	270.2	270.67	268.3	269.27	17404315.0
2018-02-07 13:30:00	SPY	ETF	269.26	270.38	268.85	269.7	7285461.0
2018-02-07 14:00:00	SPY	ETF	269.71	269.99	268.595	269.97	6962818.0
2018-02-07 14:30:00	SPY	ETF	269.97	270.12	267.97	269.0197	7579547.0
2018-02-07 15:00:00	SPY	ETF	269.01	270.535	268.88	270.27	8123060.0
2018-02-07 15:30:00	SPY	ETF	270.265	270.72	267.63	267.66	22665859.0
2018-02-07 16:00:00	SPY	ETF	267.65	267.8	266.45	266.52	15491175.0
2018-02-07 16:30:00	SPY	ETF	266.54	269.8611	266.02	266.4	2273781.0
2018-02-07 17:00:00	SPY	ETF	266.48	269.6404	266.12	266.37	268632.0
2018-02-07 17:30:00	SPY	ETF	266.35	270.8768	266.16	266.22	219085.0
2018-02-07 18:00:00	SPY	ETF	266.23	266.48	265.54	265.99	134558.0
2018-02-07 18:30:00	SPY	ETF	265.94	266.07	264.3	264.5	178502.0
2018-02-07 19:00:00	SPY	ETF	264.56	265.94	264.56	265.79	108317.0
2018-02-07 19:30:00	SPY	ETF	265.7	267.67	265.62	265.92	188474.0
2018-02-07 04:00:00	QQQ	ETF	160.72	160.8	160.33	160.7	53561.0
2018-02-07 04:30:00	QQQ	ETF	160.82	160.84	160.57	160.6	8747.0
2018-02-07 05:00:00	QQQ	ETF	160.77	161.0	160.75	161.0	11990.0
2018-02-07 05:30:00	QQQ	ETF	160.62	160.72	160.36	160.46	9729.0
2018-02-07 06:00:00	QQQ	ETF	160.42	160.78	160.42	160.71	4990.0
2018-02-07 06:30:00	QQQ	ETF	160.69	161.29	160.69	161.29	65508.0
2018-02-07 07:00:00	QQQ	ETF	161.3	161.66	161.25	161.52	141839.0
2018-02-07 07:30:00	QQQ	ETF	161.52	161.7	161.35	161.51	108197.0
2018-02-07 08:00:00	QQQ	ETF	162.31	162.31	160.02	161.42	105599.0
2018-02-07 08:30:00	QQQ	ETF	161.44	161.64	161.26	161.6	94497.0
2018-02-07 09:00:00	QQQ	ETF	161.54	162.0	161.38	161.8	200045.0
2018-02-07 09:30:00	QQQ	ETF	161.79	162.35	161.24	162.18	12852311.0
2018-02-07 10:00:00	QQQ	ETF	162.17	162.87	161.9459	162.16	6189142.0
2018-02-07 10:30:00	QQQ	ETF	162.16	162.97	161.935	162.86	4085744.0
2018-02-07 11:00:00	QQQ	ETF	162.87	163.55	162.81	163.08	3506391.0
2018-02-07 11:30:00	QQQ	ETF	163.08	163.17	162.55	162.929	2970209.0
2018-02-07 12:00:00	QQQ	ETF	162.93	163.0	162.38	162.59	2604741.0
2018-02-07 12:30:00	QQQ	ETF	162.6	162.6655	161.45	161.6	3172327.0

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

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