PREVIEW / etf_30min / 2017-12-29

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-12-29.parquet
  size:    468 KB
  rows:    16,332

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-12-29 04:00:00	SPY	ETF	267.94	268.12	267.94	268.06	837.0
2017-12-29 04:30:00	SPY	ETF	268.15	268.18	268.15	268.18	451.0
2017-12-29 05:00:00	SPY	ETF	268.3	268.45	268.3	268.4	17365.0
2017-12-29 05:30:00	SPY	ETF	268.35	268.57	268.35	268.54	24053.0
2017-12-29 06:00:00	SPY	ETF	268.52	268.6	268.52	268.6	22350.0
2017-12-29 06:30:00	SPY	ETF	268.6	268.62	268.6	268.62	5573.0
2017-12-29 07:00:00	SPY	ETF	268.58	268.98	268.56	268.85	109445.0
2017-12-29 07:30:00	SPY	ETF	268.83	268.86	268.68	268.68	214423.0
2017-12-29 08:00:00	SPY	ETF	268.58	268.84	268.56	268.64	126348.0
2017-12-29 08:30:00	SPY	ETF	268.64	268.65	268.51	268.55	137744.0
2017-12-29 09:00:00	SPY	ETF	268.54	268.66	268.46	268.53	294484.0
2017-12-29 09:30:00	SPY	ETF	268.53	268.55	267.89	267.98	4601497.0
2017-12-29 10:00:00	SPY	ETF	267.99	268.0	267.67	267.959	2018660.0
2017-12-29 10:30:00	SPY	ETF	267.96	268.01	267.52	267.725	3119581.0
2017-12-29 11:00:00	SPY	ETF	267.72	267.77	267.51	267.69	2611069.0
2017-12-29 11:30:00	SPY	ETF	267.7	267.87	267.59	267.78	3485979.0
2017-12-29 12:00:00	SPY	ETF	267.78	267.82	267.65	267.665	1964026.0
2017-12-29 12:30:00	SPY	ETF	267.655	267.7856	267.58	267.64	2252122.0
2017-12-29 13:00:00	SPY	ETF	267.64	267.72	267.55	267.6195	2043900.0
2017-12-29 13:30:00	SPY	ETF	267.61	267.64	267.29	267.42	3654070.0
2017-12-29 14:00:00	SPY	ETF	267.42	267.535	267.37	267.5	6552423.0
2017-12-29 14:30:00	SPY	ETF	267.5	267.53	267.37	267.5089	1557441.0
2017-12-29 15:00:00	SPY	ETF	267.51	267.805	267.42	267.7151	5197138.0
2017-12-29 15:30:00	SPY	ETF	267.715	267.715	266.64	266.88	17057385.0
2017-12-29 16:00:00	SPY	ETF	266.89	267.7378	266.07	266.3	31031718.0
2017-12-29 16:30:00	SPY	ETF	266.3	266.43	265.97	265.98	2014609.0
2017-12-29 17:00:00	SPY	ETF	265.99	266.86	265.98	265.98	1814473.0
2017-12-29 17:30:00	SPY	ETF	265.98	266.8601	265.85	265.93	225319.0
2017-12-29 18:00:00	SPY	ETF	265.93	265.93	265.86	265.86	62040.0
2017-12-29 18:30:00	SPY	ETF	265.86	265.9	265.77	265.78	34571.0
2017-12-29 19:00:00	SPY	ETF	265.78	266.01	265.78	265.99	46791.0
2017-12-29 19:30:00	SPY	ETF	266.01	266.12	265.99	266.0	20803.0
2017-12-29 04:30:00	QQQ	ETF	156.8	156.8	156.78	156.79	900.0
2017-12-29 05:00:00	QQQ	ETF	156.89	156.89	156.89	156.89	891.0
2017-12-29 05:30:00	QQQ	ETF	156.88	156.91	156.88	156.91	900.0
2017-12-29 06:00:00	QQQ	ETF	156.93	156.98	156.93	156.98	3200.0
2017-12-29 06:30:00	QQQ	ETF	156.94	157.1	156.94	157.04	5447.0
2017-12-29 07:00:00	QQQ	ETF	157.03	157.14	157.03	157.13	11389.0
2017-12-29 07:30:00	QQQ	ETF	157.12	157.12	157.09	157.11	4110.0
2017-12-29 08:00:00	QQQ	ETF	157.03	157.14	157.03	157.08	85413.0
2017-12-29 08:30:00	QQQ	ETF	157.09	157.09	156.92	156.93	18588.0
2017-12-29 09:00:00	QQQ	ETF	156.92	157.03	156.8	156.88	168070.0
2017-12-29 09:30:00	QQQ	ETF	156.88	156.9	156.46	156.53	2228516.0
2017-12-29 10:00:00	QQQ	ETF	156.53	156.57	156.34	156.565	1192163.0
2017-12-29 10:30:00	QQQ	ETF	156.57	156.62	156.1	156.21	3148108.0
2017-12-29 11:00:00	QQQ	ETF	156.22	156.27	156.02	156.25	2074038.0
2017-12-29 11:30:00	QQQ	ETF	156.25	156.33	156.05	156.33	1337116.0
2017-12-29 12:00:00	QQQ	ETF	156.33	156.47	156.28	156.39	839066.0
2017-12-29 12:30:00	QQQ	ETF	156.3807	156.479	156.26	156.31	851528.0
2017-12-29 13:00:00	QQQ	ETF	156.3	156.38	156.22	156.345	788392.0

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

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