PREVIEW / etf_30min / 2019-08-26

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-08-26.parquet
  size:    514 KB
  rows:    17,914

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-26 04:00:00	SPY	ETF	286.7	287.36	286.37	287.1	49348.0
2019-08-26 04:30:00	SPY	ETF	287.01	288.08	286.99	287.91	30637.0
2019-08-26 05:00:00	SPY	ETF	287.98	288.01	287.54	287.62	44402.0
2019-08-26 05:30:00	SPY	ETF	287.62	288.73	286.54	286.9	111274.0
2019-08-26 06:00:00	SPY	ETF	287.02	287.5	286.66	286.97	69886.0
2019-08-26 06:30:00	SPY	ETF	287.08	287.32	286.66	287.01	145465.0
2019-08-26 07:00:00	SPY	ETF	286.93	287.35	286.71	287.35	303927.0
2019-08-26 07:30:00	SPY	ETF	287.33	287.87	287.08	287.1	363233.0
2019-08-26 08:00:00	SPY	ETF	287.05	287.8099	283.01	286.95	768772.0
2019-08-26 08:30:00	SPY	ETF	286.92	288.07	286.81	287.73	819543.0
2019-08-26 09:00:00	SPY	ETF	287.74	287.8	287.21	287.26	760413.0
2019-08-26 09:30:00	SPY	ETF	287.27	287.63	286.19	286.88	9149763.0
2019-08-26 10:00:00	SPY	ETF	286.86	286.96	285.58	286.19	5905874.0
2019-08-26 10:30:00	SPY	ETF	286.19	286.76	285.64	286.44	5355808.0
2019-08-26 11:00:00	SPY	ETF	286.42	287.46	286.29	286.99	4926173.0
2019-08-26 11:30:00	SPY	ETF	286.99	287.21	286.47	286.92	3430698.0
2019-08-26 12:00:00	SPY	ETF	286.91	287.91	286.78	287.64	2768516.0
2019-08-26 12:30:00	SPY	ETF	287.64	287.69	287.34	287.47	2107238.0
2019-08-26 13:00:00	SPY	ETF	287.47	287.84	287.24	287.365	1884816.0
2019-08-26 13:30:00	SPY	ETF	287.365	287.365	286.95	287.13	1475238.0
2019-08-26 14:00:00	SPY	ETF	287.13	287.16	286.46	286.58	2245344.0
2019-08-26 14:30:00	SPY	ETF	286.57	287.01	286.5	286.92	6336231.0
2019-08-26 15:00:00	SPY	ETF	286.92	287.42	286.72	286.99	4184753.0
2019-08-26 15:30:00	SPY	ETF	286.995	287.99	286.7	287.97	8406600.0
2019-08-26 16:00:00	SPY	ETF	287.98	288.41	284.7553	288.35	8541742.0
2019-08-26 16:30:00	SPY	ETF	288.34	288.4	288.23	288.23	335767.0
2019-08-26 17:00:00	SPY	ETF	288.22	288.32	288.22	288.29	72466.0
2019-08-26 17:30:00	SPY	ETF	288.28	288.3	288.22	288.28	34825.0
2019-08-26 18:00:00	SPY	ETF	288.3	288.45	288.22	288.35	54449.0
2019-08-26 18:30:00	SPY	ETF	288.33	288.33	288.09	288.13	61549.0
2019-08-26 19:00:00	SPY	ETF	288.16	288.16	287.85	287.89	70210.0
2019-08-26 19:30:00	SPY	ETF	287.89	288.09	287.66	287.72	61639.0
2019-08-26 04:00:00	QQQ	ETF	184.1	184.74	183.8	184.29	62799.0
2019-08-26 04:30:00	QQQ	ETF	184.31	185.27	184.3	185.13	18869.0
2019-08-26 05:00:00	QQQ	ETF	185.19	185.19	184.71	184.8	32169.0
2019-08-26 05:30:00	QQQ	ETF	184.72	185.83	183.99	184.38	115188.0
2019-08-26 06:00:00	QQQ	ETF	184.47	185.02	184.1	184.6	49337.0
2019-08-26 06:30:00	QQQ	ETF	184.61	184.78	184.24	184.44	101275.0
2019-08-26 07:00:00	QQQ	ETF	184.28	184.56	184.15	184.54	216061.0
2019-08-26 07:30:00	QQQ	ETF	184.54	184.81	184.22	184.25	176668.0
2019-08-26 08:00:00	QQQ	ETF	184.21	185.0	181.67	184.09	512131.0
2019-08-26 08:30:00	QQQ	ETF	184.0	184.83	183.96	184.52	325162.0
2019-08-26 09:00:00	QQQ	ETF	184.49	184.53	184.13	184.19	283440.0
2019-08-26 09:30:00	QQQ	ETF	184.17	184.4	183.44	183.97	4356459.0
2019-08-26 10:00:00	QQQ	ETF	183.97	184.22	183.08	183.51	1909613.0
2019-08-26 10:30:00	QQQ	ETF	183.52	184.12	183.2	183.78	2026898.0
2019-08-26 11:00:00	QQQ	ETF	183.77	184.49	183.66	184.16	1995324.0
2019-08-26 11:30:00	QQQ	ETF	184.165	184.34	183.73	184.04	1265095.0
2019-08-26 12:00:00	QQQ	ETF	184.05	184.8297	183.93	184.56	1180404.0
2019-08-26 12:30:00	QQQ	ETF	184.57	184.62	184.33	184.47	690068.0

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

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