PREVIEW / etf_30min / 2019-04-26

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-04-26.parquet
  size:    492 KB
  rows:    17,193

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-26 04:00:00	SPY	ETF	291.55	291.67	291.53	291.67	3200.0
2019-04-26 04:30:00	SPY	ETF	291.68	291.69	291.55	291.58	2368.0
2019-04-26 05:00:00	SPY	ETF	291.57	291.57	291.5	291.53	358.0
2019-04-26 05:30:00	SPY	ETF	291.55	291.7	291.52	291.68	900.0
2019-04-26 06:00:00	SPY	ETF	291.8	291.92	291.72	291.88	7929.0
2019-04-26 06:30:00	SPY	ETF	291.89	291.89	291.89	291.89	100.0
2019-04-26 07:00:00	SPY	ETF	291.85	291.94	291.7	291.74	22582.0
2019-04-26 07:30:00	SPY	ETF	291.79	291.81	291.54	291.56	123183.0
2019-04-26 08:00:00	SPY	ETF	291.8301	291.9	291.37	291.81	176220.0
2019-04-26 08:30:00	SPY	ETF	291.84	292.51	291.81	292.15	716104.0
2019-04-26 09:00:00	SPY	ETF	292.18	292.56	292.1	292.11	276606.0
2019-04-26 09:30:00	SPY	ETF	292.1	292.25	291.3	291.51	5797027.0
2019-04-26 10:00:00	SPY	ETF	291.515	292.15	291.2401	292.1423	3423534.0
2019-04-26 10:30:00	SPY	ETF	292.141	292.27	291.93	292.04	2361701.0
2019-04-26 11:00:00	SPY	ETF	292.04	292.63	291.83	292.61	3835318.0
2019-04-26 11:30:00	SPY	ETF	292.61	292.75	292.42	292.49	2025761.0
2019-04-26 12:00:00	SPY	ETF	292.5	292.66	292.38	292.485	1419698.0
2019-04-26 12:30:00	SPY	ETF	292.49	292.7	292.4	292.48	1096993.0
2019-04-26 13:00:00	SPY	ETF	292.48	292.5	292.27	292.45	1196923.0
2019-04-26 13:30:00	SPY	ETF	292.44	292.51	292.26	292.45	1420944.0
2019-04-26 14:00:00	SPY	ETF	292.45	292.68	292.13	292.635	4253106.0
2019-04-26 14:30:00	SPY	ETF	292.64	292.705	292.53	292.64	1082410.0
2019-04-26 15:00:00	SPY	ETF	292.65	293.08	292.645	292.855	3105307.0
2019-04-26 15:30:00	SPY	ETF	292.855	293.49	292.8	293.44	8159858.0
2019-04-26 16:00:00	SPY	ETF	293.43	293.54	292.4809	293.41	7589957.0
2019-04-26 16:30:00	SPY	ETF	293.44	293.49	293.19	293.21	845607.0
2019-04-26 17:00:00	SPY	ETF	293.26	293.42	293.15	293.21	724922.0
2019-04-26 17:30:00	SPY	ETF	293.24	293.3	293.06	293.3	38343.0
2019-04-26 18:00:00	SPY	ETF	293.29	293.35	293.27	293.3	8101.0
2019-04-26 18:30:00	SPY	ETF	293.3	293.33	293.29	293.32	5057.0
2019-04-26 19:00:00	SPY	ETF	293.33	293.36	293.3	293.35	6462.0
2019-04-26 19:30:00	SPY	ETF	293.35	293.35	293.27	293.3	7285.0
2019-04-26 04:00:00	QQQ	ETF	189.84	189.87	189.72	189.72	2394.0
2019-04-26 04:30:00	QQQ	ETF	189.83	189.83	189.82	189.82	2050.0
2019-04-26 05:00:00	QQQ	ETF	189.76	189.76	189.64	189.69	700.0
2019-04-26 05:30:00	QQQ	ETF	189.68	189.83	189.68	189.8	3600.0
2019-04-26 06:00:00	QQQ	ETF	189.85	189.95	189.85	189.95	2100.0
2019-04-26 06:30:00	QQQ	ETF	189.95	189.98	189.85	189.89	11865.0
2019-04-26 07:00:00	QQQ	ETF	189.89	189.97	189.74	189.81	13185.0
2019-04-26 07:30:00	QQQ	ETF	189.82	189.82	189.62	189.67	15741.0
2019-04-26 08:00:00	QQQ	ETF	189.64	190.05	189.55	190.0	83358.0
2019-04-26 08:30:00	QQQ	ETF	190.07	190.47	190.04	190.34	344381.0
2019-04-26 09:00:00	QQQ	ETF	190.36	190.63	190.17	190.21	276710.0
2019-04-26 09:30:00	QQQ	ETF	190.2	190.24	188.74	188.94	4865443.0
2019-04-26 10:00:00	QQQ	ETF	188.95	189.59	188.59	189.52	2152047.0
2019-04-26 10:30:00	QQQ	ETF	189.51	189.72	189.32	189.62	1294666.0
2019-04-26 11:00:00	QQQ	ETF	189.62	190.01	189.46	189.97	1284725.0
2019-04-26 11:30:00	QQQ	ETF	189.975	190.092	189.76	189.83	983179.0
2019-04-26 12:00:00	QQQ	ETF	189.8201	190.0199	189.77	189.95	1022738.0
2019-04-26 12:30:00	QQQ	ETF	189.95	190.1	189.86	189.89	964687.0

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

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