PREVIEW / etf_30min / 2017-09-07

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-09-07.parquet
  size:    431 KB
  rows:    14,881

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-07 04:00:00	SPY	ETF	246.54	246.66	246.54	246.58	8450.0
2017-09-07 04:30:00	SPY	ETF	246.59	246.59	246.53	246.53	1300.0
2017-09-07 05:00:00	SPY	ETF	246.55	246.72	246.55	246.72	1550.0
2017-09-07 05:30:00	SPY	ETF	246.76	246.79	246.74	246.74	5600.0
2017-09-07 06:00:00	SPY	ETF	246.78	247.01	246.78	247.01	11455.0
2017-09-07 06:30:00	SPY	ETF	246.99	247.15	246.96	247.14	67886.0
2017-09-07 07:00:00	SPY	ETF	247.09	247.14	246.96	246.96	50871.0
2017-09-07 07:30:00	SPY	ETF	246.96	247.14	246.93	247.09	45066.0
2017-09-07 08:00:00	SPY	ETF	247.09	247.09	246.88	247.02	172324.0
2017-09-07 08:30:00	SPY	ETF	247.0	247.21	246.9	247.15	396330.0
2017-09-07 09:00:00	SPY	ETF	247.14	247.28	247.1	247.25	297967.0
2017-09-07 09:30:00	SPY	ETF	247.25	247.27	246.84	246.9	5407584.0
2017-09-07 10:00:00	SPY	ETF	246.9	246.915	246.43	246.515	6167145.0
2017-09-07 10:30:00	SPY	ETF	246.52	247.155	246.44	247.01	5663204.0
2017-09-07 11:00:00	SPY	ETF	247.005	247.14	246.56	246.65	4472802.0
2017-09-07 11:30:00	SPY	ETF	246.63	246.87	246.59	246.7	5011633.0
2017-09-07 12:00:00	SPY	ETF	246.69	246.78	246.52	246.55	3999591.0
2017-09-07 12:30:00	SPY	ETF	246.55	246.72	246.4	246.69	3349316.0
2017-09-07 13:00:00	SPY	ETF	246.69	246.82	246.6	246.76	1281838.0
2017-09-07 13:30:00	SPY	ETF	246.75	246.85	246.69	246.765	1124316.0
2017-09-07 14:00:00	SPY	ETF	246.76	246.91	246.71	246.87	1758816.0
2017-09-07 14:30:00	SPY	ETF	246.87	246.88	246.69	246.87	1843589.0
2017-09-07 15:00:00	SPY	ETF	246.88	246.9	246.6	246.639	2010150.0
2017-09-07 15:30:00	SPY	ETF	246.63	246.94	246.55	246.89	7702025.0
2017-09-07 16:00:00	SPY	ETF	246.89	247.08	246.7654	247.06	4682308.0
2017-09-07 16:30:00	SPY	ETF	247.05	247.09	246.7695	247.02	607757.0
2017-09-07 17:00:00	SPY	ETF	247.02	247.04	246.87	246.98	290370.0
2017-09-07 17:30:00	SPY	ETF	246.98	247.05	246.98	247.01	23675.0
2017-09-07 18:00:00	SPY	ETF	247.04	247.07	246.94	246.98	66786.0
2017-09-07 18:30:00	SPY	ETF	246.98	247.15	246.94	247.14	61899.0
2017-09-07 19:00:00	SPY	ETF	247.08	247.1	246.96	246.96	59393.0
2017-09-07 19:30:00	SPY	ETF	246.94	246.98	246.84	246.84	55008.0
2017-09-07 04:00:00	QQQ	ETF	145.03	145.03	145.01	145.01	500.0
2017-09-07 04:30:00	QQQ	ETF	145.03	145.03	144.98	144.98	12400.0
2017-09-07 05:00:00	QQQ	ETF	145.01	145.07	145.01	145.07	2600.0
2017-09-07 05:30:00	QQQ	ETF	145.21	145.22	145.17	145.17	19100.0
2017-09-07 06:00:00	QQQ	ETF	145.26	145.35	145.24	145.35	800.0
2017-09-07 06:30:00	QQQ	ETF	145.36	145.42	145.34	145.39	3841.0
2017-09-07 07:00:00	QQQ	ETF	145.38	145.38	145.28	145.29	9949.0
2017-09-07 07:30:00	QQQ	ETF	145.29	145.4	145.27	145.33	40160.0
2017-09-07 08:00:00	QQQ	ETF	145.34	145.35	145.21	145.28	47952.0
2017-09-07 08:30:00	QQQ	ETF	145.27	145.44	145.22	145.4	39779.0
2017-09-07 09:00:00	QQQ	ETF	145.4	145.45	145.39	145.41	47589.0
2017-09-07 09:30:00	QQQ	ETF	145.4	145.46	145.06	145.23	2618646.0
2017-09-07 10:00:00	QQQ	ETF	145.23	145.34	144.94	145.16	2157118.0
2017-09-07 10:30:00	QQQ	ETF	145.17	145.8	145.09	145.7	3137589.0
2017-09-07 11:00:00	QQQ	ETF	145.7	145.84	145.47	145.57	1614041.0
2017-09-07 11:30:00	QQQ	ETF	145.56	145.78	145.52	145.61	920087.0
2017-09-07 12:00:00	QQQ	ETF	145.61	145.61	145.29	145.29	1227266.0
2017-09-07 12:30:00	QQQ	ETF	145.31	145.4	145.06	145.25	2532055.0

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

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