PREVIEW / etf_30min / 2017-03-27

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-03-27.parquet
  size:    438 KB
  rows:    14,892

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-03-27 04:00:00	SPY	ETF	232.1	232.3	231.82	232.28	22432.0
2017-03-27 04:30:00	SPY	ETF	232.25	232.35	232.25	232.28	7854.0
2017-03-27 05:00:00	SPY	ETF	232.25	232.44	232.25	232.44	2588.0
2017-03-27 05:30:00	SPY	ETF	232.42	232.42	232.25	232.25	9991.0
2017-03-27 06:00:00	SPY	ETF	232.27	232.27	232.16	232.26	13414.0
2017-03-27 06:30:00	SPY	ETF	232.27	232.42	232.23	232.36	30201.0
2017-03-27 07:00:00	SPY	ETF	232.42	232.52	232.38	232.42	126675.0
2017-03-27 07:30:00	SPY	ETF	232.41	232.55	232.3	232.34	166232.0
2017-03-27 08:00:00	SPY	ETF	232.34	232.52	232.12	232.18	806967.0
2017-03-27 08:30:00	SPY	ETF	232.19	232.26	232.12	232.19	860521.0
2017-03-27 09:00:00	SPY	ETF	232.18	232.18	231.92	231.94	561351.0
2017-03-27 09:30:00	SPY	ETF	231.93	232.61	231.61	232.47	13331156.0
2017-03-27 10:00:00	SPY	ETF	232.47	232.56	232.14	232.39	8055327.0
2017-03-27 10:30:00	SPY	ETF	232.4	232.88	232.38	232.84	5321225.0
2017-03-27 11:00:00	SPY	ETF	232.84	233.08	232.6	233.08	4905413.0
2017-03-27 11:30:00	SPY	ETF	233.08	233.38	232.94	233.21	6875715.0
2017-03-27 12:00:00	SPY	ETF	233.21	233.47	233.11	233.23	3455323.0
2017-03-27 12:30:00	SPY	ETF	233.23	233.63	233.16	233.52	2526957.0
2017-03-27 13:00:00	SPY	ETF	233.52	233.82	233.44	233.53	2722502.0
2017-03-27 13:30:00	SPY	ETF	233.52	233.57	233.2	233.29	3515546.0
2017-03-27 14:00:00	SPY	ETF	233.29	233.51	233.02	233.216	4285632.0
2017-03-27 14:30:00	SPY	ETF	233.215	233.6	233.14	233.56	3952134.0
2017-03-27 15:00:00	SPY	ETF	233.55	233.75	233.47	233.5591	4606733.0
2017-03-27 15:30:00	SPY	ETF	233.55	233.92	233.47	233.58	13954191.0
2017-03-27 16:00:00	SPY	ETF	233.57	233.79	233.481	233.63	5381398.0
2017-03-27 16:30:00	SPY	ETF	233.64	233.79	233.63	233.79	265121.0
2017-03-27 17:00:00	SPY	ETF	233.77	233.87	233.62	233.82	339815.0
2017-03-27 17:30:00	SPY	ETF	233.82	233.85	233.78	233.85	27025.0
2017-03-27 18:00:00	SPY	ETF	233.85	233.86	233.74	233.84	55134.0
2017-03-27 18:30:00	SPY	ETF	233.84	233.84	233.76	233.81	29021.0
2017-03-27 19:00:00	SPY	ETF	233.8	233.94	233.8	233.94	22972.0
2017-03-27 19:30:00	SPY	ETF	233.93	234.02	233.91	233.98	89014.0
2017-03-27 04:00:00	QQQ	ETF	129.72	130.35	129.57	129.64	7862.0
2017-03-27 04:30:00	QQQ	ETF	129.79	129.8	129.76	129.76	2098.0
2017-03-27 05:00:00	QQQ	ETF	129.78	129.89	129.78	129.89	3149.0
2017-03-27 05:30:00	QQQ	ETF	129.92	129.93	129.85	129.89	14185.0
2017-03-27 06:00:00	QQQ	ETF	129.85	129.91	129.82	129.91	6308.0
2017-03-27 06:30:00	QQQ	ETF	129.88	129.96	129.88	129.96	4899.0
2017-03-27 07:00:00	QQQ	ETF	130.0	130.0	129.95	129.95	24731.0
2017-03-27 07:30:00	QQQ	ETF	129.97	130.0	129.94	129.94	7424.0
2017-03-27 08:00:00	QQQ	ETF	129.91	129.95	129.83	129.88	53914.0
2017-03-27 08:30:00	QQQ	ETF	129.89	129.97	129.85	129.96	78792.0
2017-03-27 09:00:00	QQQ	ETF	129.93	129.97	129.72	129.73	107765.0
2017-03-27 09:30:00	QQQ	ETF	129.72	129.96	129.4	129.93	3883291.0
2017-03-27 10:00:00	QQQ	ETF	129.91	130.25	129.81	130.15	1575522.0
2017-03-27 10:30:00	QQQ	ETF	130.16	130.4	130.14	130.35	1147565.0
2017-03-27 11:00:00	QQQ	ETF	130.34	130.52	130.18	130.52	1132665.0
2017-03-27 11:30:00	QQQ	ETF	130.52	130.68	130.4599	130.6	1677165.0
2017-03-27 12:00:00	QQQ	ETF	130.6	130.74	130.52	130.68	509063.0
2017-03-27 12:30:00	QQQ	ETF	130.68	130.95	130.62	130.88	657381.0

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

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