PREVIEW / etf_30min / 2019-08-07

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-08-07.parquet
  size:    536 KB
  rows:    18,727

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-07 04:00:00	SPY	ETF	287.49	287.85	287.46	287.56	20144.0
2019-08-07 04:30:00	SPY	ETF	287.65	288.28	287.63	288.11	9763.0
2019-08-07 05:00:00	SPY	ETF	288.23	288.23	287.96	288.11	10709.0
2019-08-07 05:30:00	SPY	ETF	288.2	288.63	288.03	288.43	15114.0
2019-08-07 06:00:00	SPY	ETF	288.43	288.53	288.22	288.25	34956.0
2019-08-07 06:30:00	SPY	ETF	288.4	288.47	287.94	287.98	38214.0
2019-08-07 07:00:00	SPY	ETF	287.96	288.19	287.8	287.91	159384.0
2019-08-07 07:30:00	SPY	ETF	287.91	287.94	287.27	287.32	300242.0
2019-08-07 08:00:00	SPY	ETF	287.86	288.1499	285.57	286.31	931617.0
2019-08-07 08:30:00	SPY	ETF	286.36	286.39	284.25	284.43	1679353.0
2019-08-07 09:00:00	SPY	ETF	284.38	284.62	283.31	284.41	1676810.0
2019-08-07 09:30:00	SPY	ETF	284.4	284.71	282.04	283.421	18562402.0
2019-08-07 10:00:00	SPY	ETF	283.42	285.38	282.91	284.54	12041690.0
2019-08-07 10:30:00	SPY	ETF	284.545	286.49	284.4	286.11	10874673.0
2019-08-07 11:00:00	SPY	ETF	286.1	286.38	285.105	285.34	7211090.0
2019-08-07 11:30:00	SPY	ETF	285.345	285.55	284.55	284.94	6591868.0
2019-08-07 12:00:00	SPY	ETF	284.975	285.1	284.2	284.74	5801047.0
2019-08-07 12:30:00	SPY	ETF	284.74	285.87	284.57	285.82	4554762.0
2019-08-07 13:00:00	SPY	ETF	285.8	286.285	285.67	286.02	4873358.0
2019-08-07 13:30:00	SPY	ETF	286.02	287.6	285.99	286.75	7026788.0
2019-08-07 14:00:00	SPY	ETF	286.76	287.53	286.3	287.11	6031212.0
2019-08-07 14:30:00	SPY	ETF	287.08	288.14	286.87	288.1	6244315.0
2019-08-07 15:00:00	SPY	ETF	288.11	288.26	287.26	288.2	6781718.0
2019-08-07 15:30:00	SPY	ETF	288.21	288.82	287.61	288.03	13794606.0
2019-08-07 16:00:00	SPY	ETF	288.01	288.34	287.62	287.73	18638020.0
2019-08-07 16:30:00	SPY	ETF	287.73	287.97	287.55	287.7	4367185.0
2019-08-07 17:00:00	SPY	ETF	287.7	287.74	287.46	287.5	222259.0
2019-08-07 17:30:00	SPY	ETF	287.5	287.981	287.45	287.54	154494.0
2019-08-07 18:00:00	SPY	ETF	287.54	287.87	287.31	287.85	279550.0
2019-08-07 18:30:00	SPY	ETF	287.81	288.01	287.68	287.97	33562.0
2019-08-07 19:00:00	SPY	ETF	287.95	288.22	287.9	288.1	31695.0
2019-08-07 19:30:00	SPY	ETF	288.02	288.02	287.06	287.16	105038.0
2019-08-07 04:00:00	QQQ	ETF	183.48	183.71	183.48	183.57	80010.0
2019-08-07 04:30:00	QQQ	ETF	183.57	184.06	183.52	183.91	25464.0
2019-08-07 05:00:00	QQQ	ETF	183.95	184.02	183.79	183.97	26166.0
2019-08-07 05:30:00	QQQ	ETF	183.99	184.32	183.9	184.21	12260.0
2019-08-07 06:00:00	QQQ	ETF	184.21	184.26	184.06	184.11	11923.0
2019-08-07 06:30:00	QQQ	ETF	184.16	184.24	183.7	183.74	26221.0
2019-08-07 07:00:00	QQQ	ETF	183.83	184.0	183.71	183.8	140999.0
2019-08-07 07:30:00	QQQ	ETF	183.8	183.8	183.25	183.3	166147.0
2019-08-07 08:00:00	QQQ	ETF	183.91	183.98	181.93	182.65	453456.0
2019-08-07 08:30:00	QQQ	ETF	182.62	182.62	181.0	181.0801	383383.0
2019-08-07 09:00:00	QQQ	ETF	181.13	181.48	180.59	181.29	691062.0
2019-08-07 09:30:00	QQQ	ETF	181.35	181.71	179.89	181.02	7183404.0
2019-08-07 10:00:00	QQQ	ETF	181.02	182.56	180.69	181.9293	3810999.0
2019-08-07 10:30:00	QQQ	ETF	181.93	183.43	181.83	183.12	4256776.0
2019-08-07 11:00:00	QQQ	ETF	183.1	183.27	182.2292	182.43	3008216.0
2019-08-07 11:30:00	QQQ	ETF	182.46	182.6141	181.85	182.09	2039324.0
2019-08-07 12:00:00	QQQ	ETF	182.1	182.18	181.371	181.7467	1674276.0
2019-08-07 12:30:00	QQQ	ETF	181.74	182.6	181.58	182.38	1526177.0

> showing 50 of 18,727 rows — these rows as CSV

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