PREVIEW / etf_30min / 2019-08-12

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-08-12.parquet
  size:    496 KB
  rows:    17,435

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-08-12 04:00:00	SPY	ETF	292.29	292.3	291.01	291.14	37431.0
2019-08-12 04:30:00	SPY	ETF	290.83	291.0	290.26	290.54	12350.0
2019-08-12 05:00:00	SPY	ETF	290.6	290.6	290.27	290.5	12166.0
2019-08-12 05:30:00	SPY	ETF	290.64	290.67	290.13	290.3	18502.0
2019-08-12 06:00:00	SPY	ETF	290.28	290.33	289.86	289.95	11840.0
2019-08-12 06:30:00	SPY	ETF	289.9	290.02	289.35	289.98	42208.0
2019-08-12 07:00:00	SPY	ETF	290.01	290.12	289.05	289.45	138325.0
2019-08-12 07:30:00	SPY	ETF	289.44	289.91	289.34	289.63	150273.0
2019-08-12 08:00:00	SPY	ETF	289.65	292.75	289.13	289.97	341884.0
2019-08-12 08:30:00	SPY	ETF	289.97	290.39	289.57	290.14	376153.0
2019-08-12 09:00:00	SPY	ETF	290.15	290.41	289.83	289.84	449789.0
2019-08-12 09:30:00	SPY	ETF	289.96	290.27	289.13	289.4	6515200.0
2019-08-12 10:00:00	SPY	ETF	289.4	290.57	289.09	290.18	5613250.0
2019-08-12 10:30:00	SPY	ETF	290.16	290.51	289.47	289.83	3616094.0
2019-08-12 11:00:00	SPY	ETF	289.82	289.83	288.59	289.14	4450533.0
2019-08-12 11:30:00	SPY	ETF	289.14	289.74	288.7	289.51	3234738.0
2019-08-12 12:00:00	SPY	ETF	289.51	289.88	289.08	289.8	2008520.0
2019-08-12 12:30:00	SPY	ETF	289.8	290.03	289.01	289.24	2353701.0
2019-08-12 13:00:00	SPY	ETF	289.25	289.38	288.81	289.06	1707611.0
2019-08-12 13:30:00	SPY	ETF	289.07	289.15	288.36	288.49	2934842.0
2019-08-12 14:00:00	SPY	ETF	288.49	291.6052	287.93	287.99	5277916.0
2019-08-12 14:30:00	SPY	ETF	287.99	288.2	287.02	287.36	6080115.0
2019-08-12 15:00:00	SPY	ETF	287.3784	288.0	287.2665	287.94	5168672.0
2019-08-12 15:30:00	SPY	ETF	287.93	291.6052	287.73	288.1	6509974.0
2019-08-12 16:00:00	SPY	ETF	288.11	288.19	287.74	287.83	1859940.0
2019-08-12 16:30:00	SPY	ETF	287.82	288.05	287.65	287.99	245775.0
2019-08-12 17:00:00	SPY	ETF	288.05	288.05	287.91	287.97	12552.0
2019-08-12 17:30:00	SPY	ETF	287.97	287.97	287.9	287.9	300.0
2019-08-12 18:00:00	SPY	ETF	288.01	288.07	287.85	288.03	13577.0
2019-08-12 18:30:00	SPY	ETF	288.03	288.24	287.97	288.23	8740.0
2019-08-12 19:00:00	SPY	ETF	288.05	288.09	288.05	288.09	600.0
2019-08-12 19:30:00	SPY	ETF	287.87	287.87	287.68	287.68	2100.0
2019-08-12 20:00:00	SPY	ETF	288.16	288.4	287.64	288.34	3292284.0
2019-08-12 04:00:00	QQQ	ETF	187.5	187.5	186.22	186.31	18533.0
2019-08-12 04:30:00	QQQ	ETF	186.28	186.28	185.55	185.81	17360.0
2019-08-12 05:00:00	QQQ	ETF	185.87	185.89	185.5	185.89	16500.0
2019-08-12 05:30:00	QQQ	ETF	185.95	186.0	185.55	185.71	13434.0
2019-08-12 06:00:00	QQQ	ETF	185.63	185.66	185.29	185.41	17130.0
2019-08-12 06:30:00	QQQ	ETF	185.36	185.36	184.86	185.32	27309.0
2019-08-12 07:00:00	QQQ	ETF	185.38	185.54	184.7	185.03	80190.0
2019-08-12 07:30:00	QQQ	ETF	184.95	185.35	184.92	185.09	63421.0
2019-08-12 08:00:00	QQQ	ETF	185.52	187.55	184.7401	185.26	115914.0
2019-08-12 08:30:00	QQQ	ETF	185.29	185.58	184.93	185.42	131882.0
2019-08-12 09:00:00	QQQ	ETF	185.41	185.5999	185.19	185.35	140784.0
2019-08-12 09:30:00	QQQ	ETF	185.35	185.78	184.63	185.01	2934263.0
2019-08-12 10:00:00	QQQ	ETF	185.01	185.82	184.7001	185.58	1941805.0
2019-08-12 10:30:00	QQQ	ETF	185.57	185.85	185.06	185.47	1198633.0
2019-08-12 11:00:00	QQQ	ETF	185.47	185.47	184.57	185.14	1269693.0
2019-08-12 11:30:00	QQQ	ETF	185.15	185.71	184.89	185.54	1038755.0
2019-08-12 12:00:00	QQQ	ETF	185.5339	185.76	185.24	185.66	910979.0

> showing 50 of 17,435 rows — these rows as CSV

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