PREVIEW / etf_30min / 2019-06-13

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-06-13.parquet
  size:    487 KB
  rows:    16,944

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
2019-06-13 04:00:00	SPY	ETF	288.99	289.25	288.85	289.1	12847.0
2019-06-13 04:30:00	SPY	ETF	289.13	289.61	289.13	289.44	30915.0
2019-06-13 05:00:00	SPY	ETF	289.4	289.55	289.29	289.51	21705.0
2019-06-13 05:30:00	SPY	ETF	289.51	289.51	289.23	289.24	9552.0
2019-06-13 06:00:00	SPY	ETF	289.17	289.41	289.17	289.4	6086.0
2019-06-13 06:30:00	SPY	ETF	289.4	289.73	289.08	289.73	24677.0
2019-06-13 07:00:00	SPY	ETF	289.73	289.77	289.41	289.45	130692.0
2019-06-13 07:30:00	SPY	ETF	289.45	289.49	289.27	289.4	86654.0
2019-06-13 08:00:00	SPY	ETF	289.2901	289.73	287.71	289.19	343233.0
2019-06-13 08:30:00	SPY	ETF	289.2	289.52	289.07	289.42	255541.0
2019-06-13 09:00:00	SPY	ETF	289.42	289.48	289.25	289.4	252812.0
2019-06-13 09:30:00	SPY	ETF	289.4	289.98	289.15	289.7	5139920.0
2019-06-13 10:00:00	SPY	ETF	289.71	289.82	288.87	289.5	4297865.0
2019-06-13 10:30:00	SPY	ETF	289.5068	289.65	288.9	288.92	3047806.0
2019-06-13 11:00:00	SPY	ETF	288.92	289.22	288.62	289.155	3002192.0
2019-06-13 11:30:00	SPY	ETF	289.15	289.36	288.97	289.27	1781282.0
2019-06-13 12:00:00	SPY	ETF	289.27	289.52	289.06	289.06	2252587.0
2019-06-13 12:30:00	SPY	ETF	289.06	289.71	289.01	289.705	2004671.0
2019-06-13 13:00:00	SPY	ETF	289.705	289.89	289.48	289.6	2845966.0
2019-06-13 13:30:00	SPY	ETF	289.6	289.6769	289.37	289.555	1295368.0
2019-06-13 14:00:00	SPY	ETF	289.55	289.6	289.03	289.35	2143773.0
2019-06-13 14:30:00	SPY	ETF	289.35	289.4	288.92	289.19	1979450.0
2019-06-13 15:00:00	SPY	ETF	289.19	289.22	288.62	288.88	4824786.0
2019-06-13 15:30:00	SPY	ETF	288.89	289.74	288.8	289.65	8038076.0
2019-06-13 16:00:00	SPY	ETF	289.66	289.79	288.4052	289.7	3166027.0
2019-06-13 16:30:00	SPY	ETF	289.71	289.85	289.5811	289.78	516361.0
2019-06-13 17:00:00	SPY	ETF	289.79	289.81	289.65	289.65	171510.0
2019-06-13 17:30:00	SPY	ETF	289.67	289.68	289.58	289.63	76303.0
2019-06-13 18:00:00	SPY	ETF	289.64	289.65	289.46	289.61	210326.0
2019-06-13 18:30:00	SPY	ETF	289.6	289.6	289.37	289.52	11762.0
2019-06-13 19:00:00	SPY	ETF	289.58	289.68	289.49	289.52	13831.0
2019-06-13 19:30:00	SPY	ETF	289.51	289.7	289.44	289.46	32236.0
2019-06-13 04:00:00	QQQ	ETF	182.84	182.97	182.78	182.97	8350.0
2019-06-13 04:30:00	QQQ	ETF	183.07	183.38	183.06	183.3	25230.0
2019-06-13 05:00:00	QQQ	ETF	183.22	183.35	183.21	183.25	6187.0
2019-06-13 05:30:00	QQQ	ETF	183.34	183.34	183.14	183.2	10011.0
2019-06-13 06:00:00	QQQ	ETF	183.09	183.27	183.05	183.27	11925.0
2019-06-13 06:30:00	QQQ	ETF	183.21	183.5	183.0	183.5	36697.0
2019-06-13 07:00:00	QQQ	ETF	183.54	183.57	183.23	183.27	46825.0
2019-06-13 07:30:00	QQQ	ETF	183.3	183.35	183.11	183.22	60339.0
2019-06-13 08:00:00	QQQ	ETF	183.38	183.5401	181.74	182.97	142621.0
2019-06-13 08:30:00	QQQ	ETF	183.08	183.27	182.87	183.18	237651.0
2019-06-13 09:00:00	QQQ	ETF	183.18	183.25	183.06	183.09	85758.0
2019-06-13 09:30:00	QQQ	ETF	183.12	183.85	182.9308	183.715	2819471.0
2019-06-13 10:00:00	QQQ	ETF	183.77	183.87	183.0899	183.54	1839973.0
2019-06-13 10:30:00	QQQ	ETF	183.54	183.7	183.09	183.12	1376513.0
2019-06-13 11:00:00	QQQ	ETF	183.11	183.36	182.8	183.18	1112249.0
2019-06-13 11:30:00	QQQ	ETF	183.17	183.41	182.99	183.32	819900.0
2019-06-13 12:00:00	QQQ	ETF	183.33	183.5	183.08	183.09	904800.0
2019-06-13 12:30:00	QQQ	ETF	183.085	183.42	182.99	183.42	923850.0

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

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