PREVIEW / etf_30min / 2018-09-06

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-09-06.parquet
  size:    470 KB
  rows:    16,126

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-09-06 04:00:00	SPY	ETF	288.75	289.04	288.54	288.97	48403.0
2018-09-06 04:30:00	SPY	ETF	289.04	289.29	289.04	289.29	2427.0
2018-09-06 05:00:00	SPY	ETF	289.37	289.42	289.24	289.32	7102.0
2018-09-06 05:30:00	SPY	ETF	289.32	289.42	289.17	289.17	2257.0
2018-09-06 06:00:00	SPY	ETF	289.17	289.29	289.17	289.19	8627.0
2018-09-06 06:30:00	SPY	ETF	289.16	289.22	288.89	288.89	5652.0
2018-09-06 07:00:00	SPY	ETF	288.87	289.07	288.74	288.94	27562.0
2018-09-06 07:30:00	SPY	ETF	289.0	289.26	289.0	289.23	65863.0
2018-09-06 08:00:00	SPY	ETF	289.21	289.42	288.41	289.22	197410.0
2018-09-06 08:30:00	SPY	ETF	289.22	289.33	289.03	289.3	161557.0
2018-09-06 09:00:00	SPY	ETF	289.3	289.39	289.06	289.17	268206.0
2018-09-06 09:30:00	SPY	ETF	289.15	289.49	288.73	289.45	4649624.0
2018-09-06 10:00:00	SPY	ETF	289.46	289.49	288.15	288.67	5743630.0
2018-09-06 10:30:00	SPY	ETF	288.6601	288.6601	287.36	287.74	7148071.0
2018-09-06 11:00:00	SPY	ETF	287.74	287.87	287.1	287.5431	6078444.0
2018-09-06 11:30:00	SPY	ETF	287.545	288.055	287.435	287.88	3902358.0
2018-09-06 12:00:00	SPY	ETF	287.88	287.92	287.57	287.63	2769214.0
2018-09-06 12:30:00	SPY	ETF	287.63	287.755	287.28	287.2885	2209287.0
2018-09-06 13:00:00	SPY	ETF	287.28	287.7	287.0	287.54	3042611.0
2018-09-06 13:30:00	SPY	ETF	287.54	287.94	287.45	287.6415	1925827.0
2018-09-06 14:00:00	SPY	ETF	287.64	287.98	287.567	287.69	2354731.0
2018-09-06 14:30:00	SPY	ETF	287.68	288.21	287.67	287.94	2845571.0
2018-09-06 15:00:00	SPY	ETF	287.945	288.65	287.945	288.55	3345950.0
2018-09-06 15:30:00	SPY	ETF	288.555	288.62	288.06	288.2	9845470.0
2018-09-06 16:00:00	SPY	ETF	288.18	288.32	287.99	288.06	6493143.0
2018-09-06 16:30:00	SPY	ETF	288.08	288.16	287.97	288.16	1414197.0
2018-09-06 17:00:00	SPY	ETF	288.02	288.16	287.52	288.05	70234.0
2018-09-06 17:30:00	SPY	ETF	288.05	288.16	287.95	287.97	53060.0
2018-09-06 18:00:00	SPY	ETF	287.98	288.04	287.96	287.96	15907.0
2018-09-06 18:30:00	SPY	ETF	288.01	288.07	287.92	288.05	17151.0
2018-09-06 19:00:00	SPY	ETF	288.07	288.09	287.94	287.94	9710.0
2018-09-06 19:30:00	SPY	ETF	287.96	288.01	287.91	287.94	8388.0
2018-09-06 04:00:00	QQQ	ETF	183.37	183.63	183.37	183.63	23128.0
2018-09-06 04:30:00	QQQ	ETF	183.59	183.72	183.57	183.67	25115.0
2018-09-06 05:00:00	QQQ	ETF	183.79	183.86	183.74	183.76	18739.0
2018-09-06 05:30:00	QQQ	ETF	183.75	183.81	183.67	183.67	4740.0
2018-09-06 06:00:00	QQQ	ETF	183.77	183.79	183.67	183.67	5628.0
2018-09-06 06:30:00	QQQ	ETF	183.67	183.67	183.42	183.43	21878.0
2018-09-06 07:00:00	QQQ	ETF	183.43	183.57	183.26	183.5	40838.0
2018-09-06 07:30:00	QQQ	ETF	183.53	183.76	183.53	183.71	101745.0
2018-09-06 08:00:00	QQQ	ETF	183.4	183.85	183.16	183.76	126705.0
2018-09-06 08:30:00	QQQ	ETF	183.76	183.82	183.58	183.77	84628.0
2018-09-06 09:00:00	QQQ	ETF	183.76	183.82	183.52	183.52	98732.0
2018-09-06 09:30:00	QQQ	ETF	183.54	183.75	182.49	183.325	4601855.0
2018-09-06 10:00:00	QQQ	ETF	183.32	183.4	181.88	182.359	4189967.0
2018-09-06 10:30:00	QQQ	ETF	182.36	182.365	181.03	181.4575	5178497.0
2018-09-06 11:00:00	QQQ	ETF	181.46	181.6	180.73	181.41	4189721.0
2018-09-06 11:30:00	QQQ	ETF	181.42	181.725	181.32	181.64	2479856.0
2018-09-06 12:00:00	QQQ	ETF	181.63	181.75	181.265	181.34	1466291.0
2018-09-06 12:30:00	QQQ	ETF	181.345	181.44	180.9	180.9	1549811.0

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

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