PREVIEW / etf_30min / 2018-01-19

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-01-19.parquet
  size:    478 KB
  rows:    16,586

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-01-19 04:00:00	SPY	ETF	279.18	279.5	279.18	279.39	3620.0
2018-01-19 04:30:00	SPY	ETF	279.47	279.55	279.43	279.53	5700.0
2018-01-19 05:00:00	SPY	ETF	279.55	279.71	279.55	279.71	5201.0
2018-01-19 05:30:00	SPY	ETF	279.63	279.75	279.57	279.66	1750.0
2018-01-19 06:00:00	SPY	ETF	279.66	279.7	279.64	279.64	26580.0
2018-01-19 06:30:00	SPY	ETF	279.65	279.75	279.65	279.68	14600.0
2018-01-19 07:00:00	SPY	ETF	279.65	279.7	279.62	279.62	38716.0
2018-01-19 07:30:00	SPY	ETF	279.6	279.6	279.5	279.52	95244.0
2018-01-19 08:00:00	SPY	ETF	279.54	279.68	279.05	279.08	125341.0
2018-01-19 08:30:00	SPY	ETF	279.11	279.24	278.81	279.13	193671.0
2018-01-19 09:00:00	SPY	ETF	279.18	279.85	279.13	279.77	1030181.0
2018-01-19 09:30:00	SPY	ETF	279.8	279.99	279.65	279.76	8580789.0
2018-01-19 10:00:00	SPY	ETF	279.7501	279.96	279.24	279.85	25041642.0
2018-01-19 10:30:00	SPY	ETF	279.85	279.94	279.35	279.5	7170336.0
2018-01-19 11:00:00	SPY	ETF	279.502	279.68	279.14	279.62	3618383.0
2018-01-19 11:30:00	SPY	ETF	279.62	279.7	279.32	279.42	6360600.0
2018-01-19 12:00:00	SPY	ETF	279.419	279.64	279.39	279.61	2200791.0
2018-01-19 12:30:00	SPY	ETF	279.6	279.8	279.5001	279.63	5963629.0
2018-01-19 13:00:00	SPY	ETF	279.63	279.69	279.43	279.66	6940634.0
2018-01-19 13:30:00	SPY	ETF	279.66	279.69	279.45	279.58	4224164.0
2018-01-19 14:00:00	SPY	ETF	279.58	280.07	279.55	279.95	7876357.0
2018-01-19 14:30:00	SPY	ETF	279.95	280.15	279.94	279.96	5797132.0
2018-01-19 15:00:00	SPY	ETF	279.96	280.32	279.84	280.3	6215646.0
2018-01-19 15:30:00	SPY	ETF	280.31	280.4	280.08	280.38	19649733.0
2018-01-19 16:00:00	SPY	ETF	280.39	280.63	280.17	280.23	24699114.0
2018-01-19 16:30:00	SPY	ETF	280.23	280.49	280.1	280.49	1541674.0
2018-01-19 17:00:00	SPY	ETF	280.43	280.49	280.32	280.41	110873.0
2018-01-19 17:30:00	SPY	ETF	280.41	280.45	280.41	280.44	91050.0
2018-01-19 18:00:00	SPY	ETF	280.45	280.55	280.45	280.49	15058.0
2018-01-19 18:30:00	SPY	ETF	280.5	280.5	280.46	280.46	1154.0
2018-01-19 19:00:00	SPY	ETF	280.5	280.55	280.46	280.46	8766.0
2018-01-19 19:30:00	SPY	ETF	280.5	280.57	280.47	280.55	14712.0
2018-01-19 04:00:00	QQQ	ETF	165.92	166.36	165.92	166.31	26880.0
2018-01-19 04:30:00	QQQ	ETF	166.3	166.42	166.3	166.35	2985.0
2018-01-19 05:00:00	QQQ	ETF	166.3	166.5	166.3	166.4	8830.0
2018-01-19 05:30:00	QQQ	ETF	166.38	166.43	166.35	166.35	800.0
2018-01-19 06:00:00	QQQ	ETF	166.35	166.42	166.31	166.35	40908.0
2018-01-19 06:30:00	QQQ	ETF	166.43	166.45	166.35	166.35	3600.0
2018-01-19 07:00:00	QQQ	ETF	166.35	166.4	166.32	166.39	16867.0
2018-01-19 07:30:00	QQQ	ETF	166.33	166.35	166.25	166.26	51954.0
2018-01-19 08:00:00	QQQ	ETF	166.28	166.33	165.81	165.97	390044.0
2018-01-19 08:30:00	QQQ	ETF	165.98	166.1	165.85	166.07	77508.0
2018-01-19 09:00:00	QQQ	ETF	166.07	166.39	166.03	166.28	151208.0
2018-01-19 09:30:00	QQQ	ETF	166.32	166.61	165.96	166.04	3224848.0
2018-01-19 10:00:00	QQQ	ETF	166.04	166.08	165.64	166.04	4834512.0
2018-01-19 10:30:00	QQQ	ETF	166.04	166.085	165.6	165.72	1813316.0
2018-01-19 11:00:00	QQQ	ETF	165.73	166.08	165.535	166.0254	1470858.0
2018-01-19 11:30:00	QQQ	ETF	166.05	166.11	165.7701	165.84	751701.0
2018-01-19 12:00:00	QQQ	ETF	165.845	166.03	165.84	166.015	598306.0
2018-01-19 12:30:00	QQQ	ETF	166.03	166.18	165.97	166.07	583388.0

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

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