PREVIEW / etf_30min / 2019-06-07

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-06-07.parquet
  size:    502 KB
  rows:    17,448

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-06-07 04:00:00	SPY	ETF	285.38	285.77	285.38	285.62	5132.0
2019-06-07 04:30:00	SPY	ETF	285.7	285.76	285.61	285.65	8010.0
2019-06-07 05:00:00	SPY	ETF	285.65	285.8	285.57	285.8	18601.0
2019-06-07 05:30:00	SPY	ETF	285.72	285.72	285.59	285.65	18510.0
2019-06-07 06:00:00	SPY	ETF	285.65	285.82	285.58	285.8	24811.0
2019-06-07 06:30:00	SPY	ETF	285.83	285.9	285.72	285.84	36530.0
2019-06-07 07:00:00	SPY	ETF	285.84	285.87	285.67	285.67	142254.0
2019-06-07 07:30:00	SPY	ETF	285.69	285.75	285.61	285.62	102126.0
2019-06-07 08:00:00	SPY	ETF	285.6217	285.87	285.15	285.76	244502.0
2019-06-07 08:30:00	SPY	ETF	285.57	286.36	284.88	285.5	2217747.0
2019-06-07 09:00:00	SPY	ETF	285.51	286.0	285.39	285.95	659084.0
2019-06-07 09:30:00	SPY	ETF	285.93	287.1	285.74	287.05	8464964.0
2019-06-07 10:00:00	SPY	ETF	287.06	287.45	287.0	287.4	5776557.0
2019-06-07 10:30:00	SPY	ETF	287.39	288.74	287.39	288.73	6807784.0
2019-06-07 11:00:00	SPY	ETF	288.73	288.85	287.81	287.85	5869286.0
2019-06-07 11:30:00	SPY	ETF	287.85	288.16	287.7	287.85	3090256.0
2019-06-07 12:00:00	SPY	ETF	287.85	288.16	287.63	288.1468	3289129.0
2019-06-07 12:30:00	SPY	ETF	288.14	288.5	287.93	288.5	2626418.0
2019-06-07 13:00:00	SPY	ETF	288.49	288.59	287.92	288.08	2216174.0
2019-06-07 13:30:00	SPY	ETF	288.095	288.38	288.07	288.295	1968380.0
2019-06-07 14:00:00	SPY	ETF	288.29	288.38	287.99	288.195	2825028.0
2019-06-07 14:30:00	SPY	ETF	288.2	288.32	287.72	287.76	4344550.0
2019-06-07 15:00:00	SPY	ETF	287.755	288.28	287.75	288.21	4700472.0
2019-06-07 15:30:00	SPY	ETF	288.2	288.28	287.5101	287.63	10995314.0
2019-06-07 16:00:00	SPY	ETF	287.63	287.9	287.35	287.6799	5586516.0
2019-06-07 16:30:00	SPY	ETF	287.68	287.99	287.64	287.98	802834.0
2019-06-07 17:00:00	SPY	ETF	287.99	287.99	287.86	287.89	61816.0
2019-06-07 17:30:00	SPY	ETF	287.86	287.96	287.65	287.88	28545.0
2019-06-07 18:00:00	SPY	ETF	287.87	287.95	287.87	287.95	3475.0
2019-06-07 18:30:00	SPY	ETF	287.94	287.96	287.94	287.96	5993.0
2019-06-07 19:00:00	SPY	ETF	287.96	288.09	287.94	288.09	9552.0
2019-06-07 19:30:00	SPY	ETF	288.05	288.13	287.96	288.04	22488.0
2019-06-07 04:00:00	QQQ	ETF	177.87	178.34	177.87	178.25	68502.0
2019-06-07 04:30:00	QQQ	ETF	178.27	178.32	178.24	178.28	12560.0
2019-06-07 05:00:00	QQQ	ETF	178.25	178.44	178.25	178.44	5660.0
2019-06-07 05:30:00	QQQ	ETF	178.46	178.46	178.29	178.33	4900.0
2019-06-07 06:00:00	QQQ	ETF	178.3	178.45	178.25	178.45	4150.0
2019-06-07 06:30:00	QQQ	ETF	178.45	178.57	178.4	178.48	7100.0
2019-06-07 07:00:00	QQQ	ETF	178.54	178.56	178.32	178.32	91699.0
2019-06-07 07:30:00	QQQ	ETF	178.33	178.39	178.27	178.28	35136.0
2019-06-07 08:00:00	QQQ	ETF	178.4101	178.5401	177.76	178.25	116931.0
2019-06-07 08:30:00	QQQ	ETF	178.04	178.89	177.74	178.3	941467.0
2019-06-07 09:00:00	QQQ	ETF	178.27	178.55	178.16	178.49	291859.0
2019-06-07 09:30:00	QQQ	ETF	178.5	179.87	178.33	179.82	6792548.0
2019-06-07 10:00:00	QQQ	ETF	179.83	180.44	179.82	180.415	2680412.0
2019-06-07 10:30:00	QQQ	ETF	180.42	181.6	180.42	181.5988	4535597.0
2019-06-07 11:00:00	QQQ	ETF	181.6	181.7666	180.97	181.01	3630068.0
2019-06-07 11:30:00	QQQ	ETF	181.015	181.32	180.85	181.0599	1837726.0
2019-06-07 12:00:00	QQQ	ETF	181.03	181.25	180.9	181.25	1273526.0
2019-06-07 12:30:00	QQQ	ETF	181.24	181.44	181.025	181.42	1454479.0

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

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