PREVIEW / etf_30min / 2019-03-11

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-03-11.parquet
  size:    496 KB
  rows:    17,335

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-11 04:00:00	SPY	ETF	275.33	275.41	275.22	275.22	4512.0
2019-03-11 04:30:00	SPY	ETF	275.08	275.08	274.98	274.98	1852.0
2019-03-11 05:00:00	SPY	ETF	274.94	275.15	274.92	275.15	4630.0
2019-03-11 05:30:00	SPY	ETF	275.15	275.25	275.14	275.25	5360.0
2019-03-11 06:00:00	SPY	ETF	275.32	275.33	275.12	275.24	6830.0
2019-03-11 06:30:00	SPY	ETF	275.21	275.25	275.0	275.2	15183.0
2019-03-11 07:00:00	SPY	ETF	275.22	275.22	275.07	275.15	45664.0
2019-03-11 07:30:00	SPY	ETF	275.2	275.47	275.2	275.29	44842.0
2019-03-11 08:00:00	SPY	ETF	275.22	275.5	275.01	275.15	110989.0
2019-03-11 08:30:00	SPY	ETF	275.17	275.7	275.17	275.55	242137.0
2019-03-11 09:00:00	SPY	ETF	275.55	275.6	275.21	275.22	259406.0
2019-03-11 09:30:00	SPY	ETF	275.26	276.33	275.23	276.29	6262112.0
2019-03-11 10:00:00	SPY	ETF	276.29	276.81	276.25	276.73	4647878.0
2019-03-11 10:30:00	SPY	ETF	276.73	277.29	276.58	277.25	4086357.0
2019-03-11 11:00:00	SPY	ETF	277.24	277.59	277.12	277.5566	3198025.0
2019-03-11 11:30:00	SPY	ETF	277.5586	277.81	277.38	277.78	4052732.0
2019-03-11 12:00:00	SPY	ETF	277.78	277.98	277.56	277.625	3102648.0
2019-03-11 12:30:00	SPY	ETF	277.61	277.86	277.61	277.65	1868724.0
2019-03-11 13:00:00	SPY	ETF	277.65	278.14	277.62	278.11	3104459.0
2019-03-11 13:30:00	SPY	ETF	278.12	278.25	277.99	278.19	2284429.0
2019-03-11 14:00:00	SPY	ETF	278.2	278.21	277.95	278.1	2654910.0
2019-03-11 14:30:00	SPY	ETF	278.09	278.34	277.98	278.145	3350822.0
2019-03-11 15:00:00	SPY	ETF	278.145	278.52	278.01	278.2825	4217952.0
2019-03-11 15:30:00	SPY	ETF	278.27	278.62	278.26	278.5	11111460.0
2019-03-11 16:00:00	SPY	ETF	278.5	278.65	275.68	278.58	6342467.0
2019-03-11 16:30:00	SPY	ETF	278.6	278.97	278.44	278.77	537934.0
2019-03-11 17:00:00	SPY	ETF	278.75	278.78	278.61	278.76	541674.0
2019-03-11 17:30:00	SPY	ETF	278.75	278.84	278.61	278.82	802647.0
2019-03-11 18:00:00	SPY	ETF	278.77	278.88	278.64	278.8	117514.0
2019-03-11 18:30:00	SPY	ETF	278.82	279.6	278.78	279.6	83776.0
2019-03-11 19:00:00	SPY	ETF	279.48	279.54	279.31	279.37	41165.0
2019-03-11 19:30:00	SPY	ETF	279.36	279.42	279.34	279.38	58570.0
2019-03-11 04:00:00	QQQ	ETF	171.6	171.89	171.6	171.73	18068.0
2019-03-11 04:30:00	QQQ	ETF	171.72	171.75	171.54	171.55	5900.0
2019-03-11 05:00:00	QQQ	ETF	171.54	171.65	171.49	171.65	26506.0
2019-03-11 05:30:00	QQQ	ETF	171.63	171.78	171.63	171.76	32431.0
2019-03-11 06:00:00	QQQ	ETF	171.8	171.9	171.78	171.85	12013.0
2019-03-11 06:30:00	QQQ	ETF	171.88	171.88	171.7	171.83	8430.0
2019-03-11 07:00:00	QQQ	ETF	171.84	171.85	171.73	171.85	39893.0
2019-03-11 07:30:00	QQQ	ETF	171.86	172.06	171.85	171.88	20395.0
2019-03-11 08:00:00	QQQ	ETF	171.84	172.0301	171.59	171.88	143970.0
2019-03-11 08:30:00	QQQ	ETF	171.86	172.23	171.86	172.12	158248.0
2019-03-11 09:00:00	QQQ	ETF	172.12	172.15	171.84	171.86	104375.0
2019-03-11 09:30:00	QQQ	ETF	171.84	173.09	171.84	173.02	2940168.0
2019-03-11 10:00:00	QQQ	ETF	173.02	173.3765	173.02	173.2967	2244595.0
2019-03-11 10:30:00	QQQ	ETF	173.28	173.67	173.18	173.65	1845187.0
2019-03-11 11:00:00	QQQ	ETF	173.649	174.0	173.57	173.94	2212537.0
2019-03-11 11:30:00	QQQ	ETF	173.94	174.2	173.84	174.15	1732125.0
2019-03-11 12:00:00	QQQ	ETF	174.15	174.36	174.02	174.18	1590917.0
2019-03-11 12:30:00	QQQ	ETF	174.18	174.39	174.1316	174.17	1137530.0

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

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