PREVIEW / etf_30min / 2019-03-15

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-03-15.parquet
  size:    488 KB
  rows:    17,009

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-03-15 04:00:00	SPY	ETF	280.54	280.54	280.4	280.43	3800.0
2019-03-15 04:30:00	SPY	ETF	280.47	280.61	280.46	280.61	1556.0
2019-03-15 05:00:00	SPY	ETF	280.63	280.63	280.48	280.48	925.0
2019-03-15 05:30:00	SPY	ETF	280.63	280.68	280.58	280.61	9966.0
2019-03-15 06:00:00	SPY	ETF	280.61	280.83	280.61	280.72	9871.0
2019-03-15 06:30:00	SPY	ETF	280.78	281.07	280.74	281.04	23913.0
2019-03-15 07:00:00	SPY	ETF	280.99	281.14	280.97	281.13	86462.0
2019-03-15 07:30:00	SPY	ETF	281.11	281.22	280.99	281.08	48649.0
2019-03-15 08:00:00	SPY	ETF	280.97	281.2	280.3	280.98	234856.0
2019-03-15 08:30:00	SPY	ETF	281.08	281.2	280.68	280.79	327660.0
2019-03-15 09:00:00	SPY	ETF	280.78	280.86	280.1	280.53	1647833.0
2019-03-15 09:30:00	SPY	ETF	280.54	281.1	280.43	280.83	6994360.0
2019-03-15 10:00:00	SPY	ETF	280.82	280.9	280.33	280.79	4807565.0
2019-03-15 10:30:00	SPY	ETF	280.79	280.89	280.37	280.67	3482491.0
2019-03-15 11:00:00	SPY	ETF	280.68	281.2	280.55	281.155	3228766.0
2019-03-15 11:30:00	SPY	ETF	281.16	281.69	280.96	281.51	6328649.0
2019-03-15 12:00:00	SPY	ETF	281.51	281.95	281.4	281.8081	3598598.0
2019-03-15 12:30:00	SPY	ETF	281.81	282.21	281.79	281.9	4986499.0
2019-03-15 13:00:00	SPY	ETF	281.91	282.04	281.73	281.75	2215796.0
2019-03-15 13:30:00	SPY	ETF	281.75	281.9351	281.6625	281.725	2414387.0
2019-03-15 14:00:00	SPY	ETF	281.725	281.769	281.33	281.45	5933433.0
2019-03-15 14:30:00	SPY	ETF	281.45	281.695	281.43	281.55	3783914.0
2019-03-15 15:00:00	SPY	ETF	281.555	281.56	281.23	281.47	7790744.0
2019-03-15 15:30:00	SPY	ETF	281.47	281.49	280.91	281.35	12353809.0
2019-03-15 16:00:00	SPY	ETF	281.37	281.64	281.052	281.54	6093949.0
2019-03-15 16:30:00	SPY	ETF	281.53	281.56	281.4	281.48	789582.0
2019-03-15 17:00:00	SPY	ETF	281.51	281.52	281.31	281.31	266014.0
2019-03-15 17:30:00	SPY	ETF	281.32	281.32	281.0	281.15	448614.0
2019-03-15 18:00:00	SPY	ETF	281.15	281.3371	281.04	281.15	330754.0
2019-03-15 18:30:00	SPY	ETF	281.14	281.25	281.14	281.19	2898.0
2019-03-15 19:00:00	SPY	ETF	281.17	281.19	281.12	281.18	12542.0
2019-03-15 19:30:00	SPY	ETF	281.17	281.22	281.07	281.11	37050.0
2019-03-15 04:00:00	QQQ	ETF	177.17	177.33	177.17	177.32	12363.0
2019-03-15 04:30:00	QQQ	ETF	177.34	177.49	177.32	177.41	9300.0
2019-03-15 05:00:00	QQQ	ETF	177.44	177.44	177.35	177.43	6400.0
2019-03-15 05:30:00	QQQ	ETF	177.42	177.44	177.38	177.4	18100.0
2019-03-15 06:00:00	QQQ	ETF	177.44	177.58	177.43	177.55	7961.0
2019-03-15 06:30:00	QQQ	ETF	177.56	177.77	177.54	177.77	122922.0
2019-03-15 07:00:00	QQQ	ETF	177.73	177.75	177.66	177.7	43874.0
2019-03-15 07:30:00	QQQ	ETF	177.7	177.78	177.54	177.63	83020.0
2019-03-15 08:00:00	QQQ	ETF	177.72	177.75	177.21	177.63	50324.0
2019-03-15 08:30:00	QQQ	ETF	177.67	177.78	177.39	177.47	123126.0
2019-03-15 09:00:00	QQQ	ETF	177.48	177.52	177.07	177.41	734929.0
2019-03-15 09:30:00	QQQ	ETF	177.41	178.2	177.28	178.06	4075164.0
2019-03-15 10:00:00	QQQ	ETF	178.06	178.13	177.6	178.0179	2584546.0
2019-03-15 10:30:00	QQQ	ETF	178.02	178.14	177.71	177.97	1474354.0
2019-03-15 11:00:00	QQQ	ETF	177.98	178.36	177.88	178.22	1519731.0
2019-03-15 11:30:00	QQQ	ETF	178.222	178.43	178.08	178.34	2052702.0
2019-03-15 12:00:00	QQQ	ETF	178.34	178.8	178.26	178.69	2282821.0
2019-03-15 12:30:00	QQQ	ETF	178.7	178.79	178.51	178.545	1267190.0

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

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