PREVIEW / etf_30min / 2018-08-07

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-08-07.parquet
  size:    464 KB
  rows:    16,051

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-08-07 04:00:00	SPY	ETF	285.2	285.38	285.17	285.38	19966.0
2018-08-07 04:30:00	SPY	ETF	285.4	285.5	285.38	285.38	14984.0
2018-08-07 05:00:00	SPY	ETF	285.38	285.45	285.32	285.32	13700.0
2018-08-07 05:30:00	SPY	ETF	285.36	285.36	285.25	285.28	9002.0
2018-08-07 06:00:00	SPY	ETF	285.28	285.34	285.18	285.23	12471.0
2018-08-07 06:30:00	SPY	ETF	285.26	285.36	285.26	285.35	58125.0
2018-08-07 07:00:00	SPY	ETF	285.31	285.35	285.27	285.31	5702.0
2018-08-07 07:30:00	SPY	ETF	285.29	285.3	285.17	285.17	67497.0
2018-08-07 08:00:00	SPY	ETF	285.31	285.32	284.99	285.21	72123.0
2018-08-07 08:30:00	SPY	ETF	285.22	285.31	285.21	285.27	103880.0
2018-08-07 09:00:00	SPY	ETF	285.28	285.41	285.28	285.38	212229.0
2018-08-07 09:30:00	SPY	ETF	285.39	285.69	285.24	285.62	5550087.0
2018-08-07 10:00:00	SPY	ETF	285.63	285.81	285.51	285.8	3140022.0
2018-08-07 10:30:00	SPY	ETF	285.8	286.01	285.59	285.7	4947747.0
2018-08-07 11:00:00	SPY	ETF	285.7	285.894	285.545	285.5846	2130926.0
2018-08-07 11:30:00	SPY	ETF	285.59	285.78	285.46	285.716	1770340.0
2018-08-07 12:00:00	SPY	ETF	285.72	285.9642	285.69	285.84	2439964.0
2018-08-07 12:30:00	SPY	ETF	285.84	285.93	285.685	285.87	1194186.0
2018-08-07 13:00:00	SPY	ETF	285.87	285.96	285.65	285.72	2425935.0
2018-08-07 13:30:00	SPY	ETF	285.72	285.91	285.57	285.845	3067452.0
2018-08-07 14:00:00	SPY	ETF	285.84	285.94	285.71	285.85	1586909.0
2018-08-07 14:30:00	SPY	ETF	285.85	285.865	285.69	285.84	1534465.0
2018-08-07 15:00:00	SPY	ETF	285.84	285.88	285.66	285.75	1855207.0
2018-08-07 15:30:00	SPY	ETF	285.755	285.76	285.41	285.54	6216552.0
2018-08-07 16:00:00	SPY	ETF	285.54	285.83	285.4418	285.5999	2633317.0
2018-08-07 16:30:00	SPY	ETF	285.6	285.77	285.58	285.72	312301.0
2018-08-07 17:00:00	SPY	ETF	285.75	285.75	285.36	285.4	169517.0
2018-08-07 17:30:00	SPY	ETF	285.4	285.6	285.4	285.6	44716.0
2018-08-07 18:00:00	SPY	ETF	285.62	285.68	285.56	285.58	68857.0
2018-08-07 18:30:00	SPY	ETF	285.6	285.64	285.49	285.54	21844.0
2018-08-07 19:00:00	SPY	ETF	285.52	285.6	285.5	285.56	13047.0
2018-08-07 19:30:00	SPY	ETF	285.51	285.59	285.51	285.56	11619.0
2018-08-07 04:00:00	QQQ	ETF	181.55	181.71	181.55	181.71	4390.0
2018-08-07 04:30:00	QQQ	ETF	181.78	181.78	181.73	181.73	1400.0
2018-08-07 05:00:00	QQQ	ETF	181.7	181.72	181.7	181.72	1387.0
2018-08-07 05:30:00	QQQ	ETF	181.73	181.73	181.64	181.66	9750.0
2018-08-07 06:00:00	QQQ	ETF	181.66	181.71	181.56	181.59	5927.0
2018-08-07 06:30:00	QQQ	ETF	181.62	181.64	181.56	181.64	16530.0
2018-08-07 07:00:00	QQQ	ETF	181.62	181.69	181.59	181.68	24624.0
2018-08-07 07:30:00	QQQ	ETF	181.63	181.65	181.54	181.54	43742.0
2018-08-07 08:00:00	QQQ	ETF	181.5799	181.63	181.39	181.58	99462.0
2018-08-07 08:30:00	QQQ	ETF	181.55	181.63	181.51	181.61	120155.0
2018-08-07 09:00:00	QQQ	ETF	181.61	181.65	181.55	181.64	74280.0
2018-08-07 09:30:00	QQQ	ETF	181.63	182.14	181.33	181.78	5454610.0
2018-08-07 10:00:00	QQQ	ETF	181.77	181.94	181.56	181.94	2735327.0
2018-08-07 10:30:00	QQQ	ETF	181.95	182.1	181.35	181.45	2632558.0
2018-08-07 11:00:00	QQQ	ETF	181.45	181.7199	181.26	181.37	1946241.0
2018-08-07 11:30:00	QQQ	ETF	181.36	181.6699	181.29	181.61	1079895.0
2018-08-07 12:00:00	QQQ	ETF	181.62	181.92	181.57	181.82	879877.0
2018-08-07 12:30:00	QQQ	ETF	181.82	182.04	181.69	181.95	788795.0

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

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