PREVIEW / etf_30min / 2018-08-08

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-08-08.parquet
  size:    453 KB
  rows:    15,675

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-08 04:00:00	SPY	ETF	285.56	285.6	285.45	285.45	850.0
2018-08-08 04:30:00	SPY	ETF	285.61	285.61	285.6	285.6	750.0
2018-08-08 05:00:00	SPY	ETF	285.63	285.63	285.6	285.63	1200.0
2018-08-08 05:30:00	SPY	ETF	285.55	285.63	285.55	285.63	400.0
2018-08-08 06:00:00	SPY	ETF	285.63	285.7	285.63	285.7	4150.0
2018-08-08 06:30:00	SPY	ETF	285.72	285.75	285.72	285.75	4700.0
2018-08-08 07:00:00	SPY	ETF	285.71	285.75	285.7	285.72	3403.0
2018-08-08 07:30:00	SPY	ETF	285.74	285.8	285.6	285.6	17237.0
2018-08-08 08:00:00	SPY	ETF	285.73	285.73	285.38	285.38	85815.0
2018-08-08 08:30:00	SPY	ETF	285.38	285.39	285.16	285.28	176563.0
2018-08-08 09:00:00	SPY	ETF	285.26	285.41	285.25	285.38	77453.0
2018-08-08 09:30:00	SPY	ETF	285.39	285.47	285.04	285.165	3734692.0
2018-08-08 10:00:00	SPY	ETF	285.17	285.35	285.01	285.18	2486488.0
2018-08-08 10:30:00	SPY	ETF	285.18	285.6	284.94	285.57	2743348.0
2018-08-08 11:00:00	SPY	ETF	285.58	285.66	285.49	285.63	1815419.0
2018-08-08 11:30:00	SPY	ETF	285.63	285.76	285.39	285.42	1488002.0
2018-08-08 12:00:00	SPY	ETF	285.43	285.46	285.21	285.3	1136057.0
2018-08-08 12:30:00	SPY	ETF	285.3	285.625	285.29	285.435	1247375.0
2018-08-08 13:00:00	SPY	ETF	285.435	285.54	285.37	285.46	1379722.0
2018-08-08 13:30:00	SPY	ETF	285.4564	285.7	285.37	285.68	1590715.0
2018-08-08 14:00:00	SPY	ETF	285.68	285.75	285.55	285.74	1479974.0
2018-08-08 14:30:00	SPY	ETF	285.75	285.77	285.58	285.65	1496480.0
2018-08-08 15:00:00	SPY	ETF	285.645	285.825	285.59	285.82	3153875.0
2018-08-08 15:30:00	SPY	ETF	285.82	285.91	285.37	285.42	9130725.0
2018-08-08 16:00:00	SPY	ETF	285.41	285.4918	285.14	285.15	6300636.0
2018-08-08 16:30:00	SPY	ETF	285.15	285.46	284.95	285.01	1133621.0
2018-08-08 17:00:00	SPY	ETF	285.02	285.07	284.98	285.07	41585.0
2018-08-08 17:30:00	SPY	ETF	285.07	285.07	284.95	285.01	62624.0
2018-08-08 18:00:00	SPY	ETF	284.97	285.17	284.95	285.13	64001.0
2018-08-08 18:30:00	SPY	ETF	285.12	285.13	285.12	285.13	9175.0
2018-08-08 19:00:00	SPY	ETF	285.12	285.12	285.08	285.09	5055.0
2018-08-08 19:30:00	SPY	ETF	285.11	285.17	285.11	285.14	15920.0
2018-08-08 04:00:00	QQQ	ETF	181.78	181.84	181.76	181.84	4458.0
2018-08-08 04:30:00	QQQ	ETF	181.82	181.84	181.78	181.78	8200.0
2018-08-08 05:00:00	QQQ	ETF	181.85	181.92	181.85	181.85	1700.0
2018-08-08 05:30:00	QQQ	ETF	181.81	181.86	181.78	181.83	2203.0
2018-08-08 06:00:00	QQQ	ETF	181.9	181.9	181.88	181.88	300.0
2018-08-08 06:30:00	QQQ	ETF	181.87	181.9	181.87	181.9	4138.0
2018-08-08 07:00:00	QQQ	ETF	181.91	181.99	181.91	181.96	7594.0
2018-08-08 07:30:00	QQQ	ETF	181.94	181.98	181.79	181.79	28231.0
2018-08-08 08:00:00	QQQ	ETF	181.9399	181.9399	181.49	181.5	99216.0
2018-08-08 08:30:00	QQQ	ETF	181.51	181.55	181.33	181.4	89489.0
2018-08-08 09:00:00	QQQ	ETF	181.44	181.52	181.38	181.52	58495.0
2018-08-08 09:30:00	QQQ	ETF	181.55	181.74	181.06	181.54	2939887.0
2018-08-08 10:00:00	QQQ	ETF	181.54	181.86	181.41	181.635	1769604.0
2018-08-08 10:30:00	QQQ	ETF	181.64	182.35	181.45	182.25	1974777.0
2018-08-08 11:00:00	QQQ	ETF	182.26	182.28	182.03	182.14	1118816.0
2018-08-08 11:30:00	QQQ	ETF	182.16	182.29	181.77	181.79	1088390.0
2018-08-08 12:00:00	QQQ	ETF	181.79	181.9	181.631	181.81	750689.0
2018-08-08 12:30:00	QQQ	ETF	181.811	182.07	181.81	181.91	765814.0

> showing 50 of 15,675 rows — these rows as CSV

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