PREVIEW / etf_30min / 2019-11-22

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-11-22.parquet
  size:    500 KB
  rows:    17,398

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-11-22 04:00:00	SPY	ETF	311.3	311.42	310.96	311.03	15582.0
2019-11-22 04:30:00	SPY	ETF	310.97	311.05	310.94	311.05	4870.0
2019-11-22 05:00:00	SPY	ETF	311.06	311.15	310.96	311.13	5930.0
2019-11-22 05:30:00	SPY	ETF	311.08	311.08	310.9	310.97	14571.0
2019-11-22 06:00:00	SPY	ETF	310.95	311.0	310.62	310.76	19499.0
2019-11-22 06:30:00	SPY	ETF	310.74	310.9	310.72	310.9	9328.0
2019-11-22 07:00:00	SPY	ETF	310.91	311.11	310.91	311.01	24343.0
2019-11-22 07:30:00	SPY	ETF	311.02	311.04	310.9	311.0	57971.0
2019-11-22 08:00:00	SPY	ETF	311.0099	311.4	310.73	310.78	56997.0
2019-11-22 08:30:00	SPY	ETF	310.81	311.18	310.62	311.09	427951.0
2019-11-22 09:00:00	SPY	ETF	311.06	311.17	310.94	311.07	73099.0
2019-11-22 09:30:00	SPY	ETF	311.09	311.22	310.72	311.08	3377053.0
2019-11-22 10:00:00	SPY	ETF	311.08	311.24	310.5	310.51	3379630.0
2019-11-22 10:30:00	SPY	ETF	310.515	310.77	310.17	310.4	5189957.0
2019-11-22 11:00:00	SPY	ETF	310.4	310.505	309.85	310.29	2720193.0
2019-11-22 11:30:00	SPY	ETF	310.3	310.67	310.23	310.53	1536194.0
2019-11-22 12:00:00	SPY	ETF	310.54	310.77	310.49	310.72	1301843.0
2019-11-22 12:30:00	SPY	ETF	310.73	310.92	310.6095	310.85	1292648.0
2019-11-22 13:00:00	SPY	ETF	310.84	310.97	310.81	310.88	1389938.0
2019-11-22 13:30:00	SPY	ETF	310.89	310.95	310.7	310.895	1835032.0
2019-11-22 14:00:00	SPY	ETF	310.9	310.91	310.71	310.8	1420448.0
2019-11-22 14:30:00	SPY	ETF	310.8	311.0	310.79	310.9	1739942.0
2019-11-22 15:00:00	SPY	ETF	310.91	311.03	310.8	310.98	1943700.0
2019-11-22 15:30:00	SPY	ETF	310.97	311.025	310.58	311.0	7340539.0
2019-11-22 16:00:00	SPY	ETF	310.98	311.21	310.721	311.15	7305686.0
2019-11-22 16:30:00	SPY	ETF	311.14	311.22	310.3088	311.19	383350.0
2019-11-22 17:00:00	SPY	ETF	311.19	311.19	310.96	311.15	1118399.0
2019-11-22 17:30:00	SPY	ETF	311.15	311.2	311.12	311.16	4661.0
2019-11-22 18:00:00	SPY	ETF	311.18	311.2	311.14	311.19	8518.0
2019-11-22 18:30:00	SPY	ETF	311.19	311.2	311.17	311.19	2606.0
2019-11-22 19:00:00	SPY	ETF	311.19	311.19	311.16	311.16	2591.0
2019-11-22 19:30:00	SPY	ETF	311.17	311.22	311.15	311.15	19843.0
2019-11-22 04:00:00	QQQ	ETF	202.55	202.55	202.23	202.24	9340.0
2019-11-22 04:30:00	QQQ	ETF	202.19	202.36	202.19	202.36	3714.0
2019-11-22 05:00:00	QQQ	ETF	202.39	202.45	202.34	202.44	13800.0
2019-11-22 05:30:00	QQQ	ETF	202.33	202.35	202.29	202.31	2810.0
2019-11-22 06:00:00	QQQ	ETF	202.35	202.35	202.05	202.12	10654.0
2019-11-22 06:30:00	QQQ	ETF	202.19	202.25	202.18	202.2	4245.0
2019-11-22 07:00:00	QQQ	ETF	202.27	202.43	202.26	202.33	17530.0
2019-11-22 07:30:00	QQQ	ETF	202.3	202.32	202.21	202.24	8119.0
2019-11-22 08:00:00	QQQ	ETF	202.4	202.6	202.07	202.1	42410.0
2019-11-22 08:30:00	QQQ	ETF	202.1	202.33	201.9	202.25	226743.0
2019-11-22 09:00:00	QQQ	ETF	202.23	202.31	202.13	202.14	42336.0
2019-11-22 09:30:00	QQQ	ETF	202.17	202.32	201.8	202.01	1688789.0
2019-11-22 10:00:00	QQQ	ETF	202.01	202.15	201.4	201.41	1069109.0
2019-11-22 10:30:00	QQQ	ETF	201.41	201.41	200.99	201.2062	1463907.0
2019-11-22 11:00:00	QQQ	ETF	201.21	201.32	200.74	201.29	1364396.0
2019-11-22 11:30:00	QQQ	ETF	201.3	201.5	201.21	201.365	527147.0
2019-11-22 12:00:00	QQQ	ETF	201.37	201.66	201.3401	201.6	575757.0
2019-11-22 12:30:00	QQQ	ETF	201.6	201.74	201.5	201.69	458015.0

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

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