PREVIEW / etf_30min / 2018-10-05

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-10-05.parquet
  size:    495 KB
  rows:    16,823

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-10-05 04:00:00	SPY	ETF	289.47	289.58	289.21	289.24	5910.0
2018-10-05 04:30:00	SPY	ETF	289.1	289.21	289.1	289.21	11070.0
2018-10-05 05:00:00	SPY	ETF	289.27	289.31	289.23	289.28	3890.0
2018-10-05 05:30:00	SPY	ETF	289.36	289.44	289.29	289.37	8300.0
2018-10-05 06:00:00	SPY	ETF	289.46	289.63	289.46	289.63	13440.0
2018-10-05 06:30:00	SPY	ETF	289.58	289.58	289.46	289.54	19810.0
2018-10-05 07:00:00	SPY	ETF	289.56	289.89	289.55	289.81	56434.0
2018-10-05 07:30:00	SPY	ETF	289.84	289.84	289.62	289.62	48179.0
2018-10-05 08:00:00	SPY	ETF	289.44	289.87	289.24	289.5	170881.0
2018-10-05 08:30:00	SPY	ETF	289.46	290.35	288.74	289.54	1384635.0
2018-10-05 09:00:00	SPY	ETF	289.54	290.3	289.51	289.68	566502.0
2018-10-05 09:30:00	SPY	ETF	289.69	290.27	289.4	289.42	8840018.0
2018-10-05 10:00:00	SPY	ETF	289.43	289.86	289.15	289.73	5647026.0
2018-10-05 10:30:00	SPY	ETF	289.73	289.75	288.855	289.04	5177006.0
2018-10-05 11:00:00	SPY	ETF	289.03	289.0685	287.92	288.16	8022400.0
2018-10-05 11:30:00	SPY	ETF	288.17	288.32	287.01	287.04	8969421.0
2018-10-05 12:00:00	SPY	ETF	287.045	287.58	286.97	287.31	6024887.0
2018-10-05 12:30:00	SPY	ETF	287.31	287.33	286.61	286.952	6775566.0
2018-10-05 13:00:00	SPY	ETF	286.95	286.98	286.23	286.42	4308099.0
2018-10-05 13:30:00	SPY	ETF	286.41	287.38	286.22	287.23	5972110.0
2018-10-05 14:00:00	SPY	ETF	287.23	287.71	287.0	287.67	4772445.0
2018-10-05 14:30:00	SPY	ETF	287.67	288.05	287.52	287.945	4539000.0
2018-10-05 15:00:00	SPY	ETF	287.95	288.31	287.71	287.93	5317135.0
2018-10-05 15:30:00	SPY	ETF	287.93	288.36	287.42	287.89	13786717.0
2018-10-05 16:00:00	SPY	ETF	287.89	288.31	287.8	288.26	10832617.0
2018-10-05 16:30:00	SPY	ETF	288.25	288.35	288.09	288.35	270927.0
2018-10-05 17:00:00	SPY	ETF	288.25	288.32	288.2	288.31	49618.0
2018-10-05 17:30:00	SPY	ETF	288.31	288.31	288.06	288.16	64602.0
2018-10-05 18:00:00	SPY	ETF	288.13	288.18	287.98	288.16	83055.0
2018-10-05 18:30:00	SPY	ETF	288.15	288.28	288.15	288.28	23505.0
2018-10-05 19:00:00	SPY	ETF	288.15	288.15	288.14	288.15	500.0
2018-10-05 19:30:00	SPY	ETF	288.18	288.18	288.1	288.11	13696.0
2018-10-05 04:00:00	QQQ	ETF	181.99	182.0	181.75	181.75	33700.0
2018-10-05 04:30:00	QQQ	ETF	181.8	181.85	181.6	181.72	1210.0
2018-10-05 05:00:00	QQQ	ETF	181.9	182.04	181.9	182.03	15039.0
2018-10-05 05:30:00	QQQ	ETF	181.94	182.1	181.94	182.1	7100.0
2018-10-05 06:00:00	QQQ	ETF	182.16	182.26	182.16	182.21	14900.0
2018-10-05 06:30:00	QQQ	ETF	182.2	182.2	182.08	182.18	53055.0
2018-10-05 07:00:00	QQQ	ETF	182.19	182.5	182.18	182.38	90864.0
2018-10-05 07:30:00	QQQ	ETF	182.37	182.39	182.17	182.21	74102.0
2018-10-05 08:00:00	QQQ	ETF	182.4999	182.52	181.79	182.04	134175.0
2018-10-05 08:30:00	QQQ	ETF	181.74	182.98	181.41	182.17	1242368.0
2018-10-05 09:00:00	QQQ	ETF	182.2	182.67	182.15	182.4	225857.0
2018-10-05 09:30:00	QQQ	ETF	182.39	182.97	181.47	181.61	7831055.0
2018-10-05 10:00:00	QQQ	ETF	181.61	182.26	181.25	182.07	4486835.0
2018-10-05 10:30:00	QQQ	ETF	182.07	182.11	181.05	181.37	3208756.0
2018-10-05 11:00:00	QQQ	ETF	181.37	181.39	179.98	180.27	7014233.0
2018-10-05 11:30:00	QQQ	ETF	180.26	180.46	179.35	179.47	6058158.0
2018-10-05 12:00:00	QQQ	ETF	179.48	179.92	179.4	179.64	4915623.0
2018-10-05 12:30:00	QQQ	ETF	179.64	179.66	178.795	179.1	5611543.0

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

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