PREVIEW / etf_30min / 2017-09-08

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-09-08.parquet
  size:    425 KB
  rows:    14,733

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
2017-09-08 04:00:00	SPY	ETF	246.51	246.55	246.36	246.36	4979.0
2017-09-08 04:30:00	SPY	ETF	246.36	246.44	246.26	246.27	4485.0
2017-09-08 05:00:00	SPY	ETF	246.52	246.6	246.52	246.58	750.0
2017-09-08 05:30:00	SPY	ETF	246.6	246.64	246.4	246.4	1001.0
2017-09-08 06:00:00	SPY	ETF	246.5	246.5	246.4	246.4	854.0
2017-09-08 06:30:00	SPY	ETF	246.28	246.3	246.14	246.18	18442.0
2017-09-08 07:00:00	SPY	ETF	246.2	246.38	246.18	246.35	57613.0
2017-09-08 07:30:00	SPY	ETF	246.37	246.45	246.33	246.43	51623.0
2017-09-08 08:00:00	SPY	ETF	246.18	246.52	246.18	246.5	119066.0
2017-09-08 08:30:00	SPY	ETF	246.5	246.58	246.45	246.55	117393.0
2017-09-08 09:00:00	SPY	ETF	246.56	246.56	246.43	246.53	119860.0
2017-09-08 09:30:00	SPY	ETF	246.54	246.72	246.3	246.71	5419934.0
2017-09-08 10:00:00	SPY	ETF	246.71	246.87	246.57	246.665	4957772.0
2017-09-08 10:30:00	SPY	ETF	246.65	246.8642	246.55	246.83	2150959.0
2017-09-08 11:00:00	SPY	ETF	246.83	247.11	246.79	246.93	2889171.0
2017-09-08 11:30:00	SPY	ETF	246.93	246.99	246.74	246.77	2236299.0
2017-09-08 12:00:00	SPY	ETF	246.77	246.82	246.58	246.78	1943260.0
2017-09-08 12:30:00	SPY	ETF	246.78	246.91	246.76	246.85	1148157.0
2017-09-08 13:00:00	SPY	ETF	246.85	246.86	246.75	246.76	3115930.0
2017-09-08 13:30:00	SPY	ETF	246.765	246.77	246.63	246.735	2071118.0
2017-09-08 14:00:00	SPY	ETF	246.75	246.85	246.69	246.775	3920617.0
2017-09-08 14:30:00	SPY	ETF	246.775	246.94	246.63	246.76	2912865.0
2017-09-08 15:00:00	SPY	ETF	246.75	246.82	246.48	246.49	3437184.0
2017-09-08 15:30:00	SPY	ETF	246.49	246.61	246.36	246.55	10396272.0
2017-09-08 16:00:00	SPY	ETF	246.56	246.8752	246.523	246.65	12148655.0
2017-09-08 16:30:00	SPY	ETF	246.66	246.71	246.58	246.68	585829.0
2017-09-08 17:00:00	SPY	ETF	246.66	246.68	246.62	246.64	21429.0
2017-09-08 17:30:00	SPY	ETF	246.63	246.66	246.61	246.62	46739.0
2017-09-08 18:00:00	SPY	ETF	246.65	246.67	246.63	246.67	12294.0
2017-09-08 18:30:00	SPY	ETF	246.67	246.72	246.65	246.67	26299.0
2017-09-08 19:00:00	SPY	ETF	246.68	246.7	246.66	246.66	2105.0
2017-09-08 19:30:00	SPY	ETF	246.68	246.71	246.67	246.7	12730.0
2017-09-08 04:00:00	QQQ	ETF	145.13	145.19	145.13	145.15	2050.0
2017-09-08 04:30:00	QQQ	ETF	145.14	145.14	145.12	145.12	6300.0
2017-09-08 05:00:00	QQQ	ETF	145.1	145.39	145.1	145.39	1862.0
2017-09-08 05:30:00	QQQ	ETF	145.4	145.4	145.29	145.29	800.0
2017-09-08 06:00:00	QQQ	ETF	145.28	145.28	145.15	145.2	7298.0
2017-09-08 06:30:00	QQQ	ETF	145.26	145.26	145.08	145.08	2938.0
2017-09-08 07:00:00	QQQ	ETF	145.09	145.21	145.08	145.21	20908.0
2017-09-08 07:30:00	QQQ	ETF	145.21	145.23	145.15	145.23	37018.0
2017-09-08 08:00:00	QQQ	ETF	145.22	145.3	145.17	145.3	71867.0
2017-09-08 08:30:00	QQQ	ETF	145.3	145.35	145.27	145.3	37476.0
2017-09-08 09:00:00	QQQ	ETF	145.34	145.34	145.19	145.27	37012.0
2017-09-08 09:30:00	QQQ	ETF	145.28	145.35	144.925	145.1	3191586.0
2017-09-08 10:00:00	QQQ	ETF	145.1	145.14	144.75	144.93	2737470.0
2017-09-08 10:30:00	QQQ	ETF	144.92	144.97	144.74	144.89	1400403.0
2017-09-08 11:00:00	QQQ	ETF	144.9	145.095	144.85	144.93	1127165.0
2017-09-08 11:30:00	QQQ	ETF	144.93	144.96	144.62	144.71	1209915.0
2017-09-08 12:00:00	QQQ	ETF	144.7125	144.76	144.53	144.62	1334106.0
2017-09-08 12:30:00	QQQ	ETF	144.62	144.74	144.6	144.64	902047.0

> showing 50 of 14,733 rows — these rows as CSV

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