PREVIEW / etf_30min / 2019-04-25

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-04-25.parquet
  size:    496 KB
  rows:    17,422

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-04-25 04:00:00	SPY	ETF	292.23	292.34	292.12	292.18	9484.0
2019-04-25 04:30:00	SPY	ETF	292.23	292.5	292.22	292.5	1084.0
2019-04-25 05:00:00	SPY	ETF	292.56	292.56	292.42	292.42	1554.0
2019-04-25 05:30:00	SPY	ETF	292.47	292.5	292.3	292.3	4800.0
2019-04-25 06:00:00	SPY	ETF	292.37	292.48	292.37	292.4	3307.0
2019-04-25 06:30:00	SPY	ETF	292.4	292.4	292.05	292.23	20337.0
2019-04-25 07:00:00	SPY	ETF	292.28	292.45	292.28	292.38	70345.0
2019-04-25 07:30:00	SPY	ETF	292.41	292.55	292.4	292.55	106283.0
2019-04-25 08:00:00	SPY	ETF	292.38	292.8	292.38	292.62	136572.0
2019-04-25 08:30:00	SPY	ETF	292.67	292.74	292.44	292.48	311419.0
2019-04-25 09:00:00	SPY	ETF	292.48	292.5	292.1	292.11	550115.0
2019-04-25 09:30:00	SPY	ETF	292.12	292.1659	291.23	291.84	6623529.0
2019-04-25 10:00:00	SPY	ETF	291.85	292.07	290.78	291.1759	6434058.0
2019-04-25 10:30:00	SPY	ETF	291.17	291.71	290.73	291.69	4512332.0
2019-04-25 11:00:00	SPY	ETF	291.68	292.32	291.535	292.21	5981171.0
2019-04-25 11:30:00	SPY	ETF	292.22	292.78	292.22	292.61	3384729.0
2019-04-25 12:00:00	SPY	ETF	292.61	292.73	292.23	292.23	3142629.0
2019-04-25 12:30:00	SPY	ETF	292.24	292.46	292.23	292.42	1144689.0
2019-04-25 13:00:00	SPY	ETF	292.42	292.52	292.28	292.52	1426493.0
2019-04-25 13:30:00	SPY	ETF	292.53	292.585	292.34	292.545	958159.0
2019-04-25 14:00:00	SPY	ETF	292.55	292.78	292.54	292.63	1862069.0
2019-04-25 14:30:00	SPY	ETF	292.63	292.71	292.54	292.69	1329482.0
2019-04-25 15:00:00	SPY	ETF	292.69	292.7	292.29	292.5601	2470423.0
2019-04-25 15:30:00	SPY	ETF	292.57	292.76	292.07	292.08	7508808.0
2019-04-25 16:00:00	SPY	ETF	292.07	292.3727	291.75	291.99	4059297.0
2019-04-25 16:30:00	SPY	ETF	291.97	292.06	291.63	291.65	366358.0
2019-04-25 17:00:00	SPY	ETF	291.7	291.74	291.29	291.41	3567209.0
2019-04-25 17:30:00	SPY	ETF	291.37	292.05	291.36	291.7	511320.0
2019-04-25 18:00:00	SPY	ETF	291.68	292.05	291.52	291.8	87561.0
2019-04-25 18:30:00	SPY	ETF	291.78	291.81	291.74	291.74	9894.0
2019-04-25 19:00:00	SPY	ETF	291.76	291.8	291.72	291.78	8920.0
2019-04-25 19:30:00	SPY	ETF	291.78	291.8	291.59	291.62	22923.0
2019-04-25 04:00:00	QQQ	ETF	190.98	191.02	190.86	190.96	12115.0
2019-04-25 04:30:00	QQQ	ETF	190.96	191.14	190.92	191.11	18307.0
2019-04-25 05:00:00	QQQ	ETF	191.14	191.17	191.13	191.14	4900.0
2019-04-25 05:30:00	QQQ	ETF	191.13	191.13	190.97	191.01	7400.0
2019-04-25 06:00:00	QQQ	ETF	191.01	191.16	191.01	191.11	8400.0
2019-04-25 06:30:00	QQQ	ETF	191.09	191.18	190.97	191.11	20561.0
2019-04-25 07:00:00	QQQ	ETF	191.15	191.31	191.15	191.26	40121.0
2019-04-25 07:30:00	QQQ	ETF	191.29	191.39	191.23	191.37	52427.0
2019-04-25 08:00:00	QQQ	ETF	191.24	191.58	190.99	191.54	155071.0
2019-04-25 08:30:00	QQQ	ETF	191.54	191.5601	191.41	191.46	178166.0
2019-04-25 09:00:00	QQQ	ETF	191.44	191.47	191.16	191.16	138037.0
2019-04-25 09:30:00	QQQ	ETF	191.15	191.22	190.3931	190.91	4750183.0
2019-04-25 10:00:00	QQQ	ETF	190.92	191.11	189.45	190.0266	3354198.0
2019-04-25 10:30:00	QQQ	ETF	190.02	190.52	189.74	190.48	1960531.0
2019-04-25 11:00:00	QQQ	ETF	190.48	190.81	190.08	190.71	2257495.0
2019-04-25 11:30:00	QQQ	ETF	190.72	190.99	190.64	190.83	1374256.0
2019-04-25 12:00:00	QQQ	ETF	190.85	190.945	190.51	190.51	917882.0
2019-04-25 12:30:00	QQQ	ETF	190.51	190.7	190.51	190.6276	670068.0

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

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