PREVIEW / etf_30min / 2019-11-21

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-11-21.parquet
  size:    503 KB
  rows:    17,604

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-21 04:00:00	SPY	ETF	310.42	310.51	310.32	310.34	9325.0
2019-11-21 04:30:00	SPY	ETF	310.34	310.51	310.34	310.41	3300.0
2019-11-21 05:00:00	SPY	ETF	310.4	311.22	310.4	310.93	26253.0
2019-11-21 05:30:00	SPY	ETF	310.95	310.95	310.68	310.77	9875.0
2019-11-21 06:00:00	SPY	ETF	310.77	310.77	310.63	310.7	15522.0
2019-11-21 06:30:00	SPY	ETF	310.7	310.92	310.7	310.88	39530.0
2019-11-21 07:00:00	SPY	ETF	310.86	310.9	310.6	310.61	83256.0
2019-11-21 07:30:00	SPY	ETF	310.66	310.92	310.63	310.85	120168.0
2019-11-21 08:00:00	SPY	ETF	310.81	311.48	309.97	311.29	576992.0
2019-11-21 08:30:00	SPY	ETF	311.25	311.34	310.94	310.99	242981.0
2019-11-21 09:00:00	SPY	ETF	310.97	311.11	310.8	310.8	180678.0
2019-11-21 09:30:00	SPY	ETF	310.89	311.01	310.05	310.29	4960166.0
2019-11-21 10:00:00	SPY	ETF	310.3	310.56	309.59	309.66	6463173.0
2019-11-21 10:30:00	SPY	ETF	309.67	310.12	309.39	310.07	4854821.0
2019-11-21 11:00:00	SPY	ETF	310.0739	310.3999	309.95	310.03	2227987.0
2019-11-21 11:30:00	SPY	ETF	310.0241	310.1925	309.74	309.84	2101809.0
2019-11-21 12:00:00	SPY	ETF	309.84	310.345	309.76	310.24	1491606.0
2019-11-21 12:30:00	SPY	ETF	310.25	310.63	310.21	310.5	1807412.0
2019-11-21 13:00:00	SPY	ETF	310.5	310.63	310.41	310.51	1266007.0
2019-11-21 13:30:00	SPY	ETF	310.51	310.59	310.32	310.38	1530647.0
2019-11-21 14:00:00	SPY	ETF	310.375	310.74	310.12	310.677	2720747.0
2019-11-21 14:30:00	SPY	ETF	310.67	310.83	310.65	310.695	1384104.0
2019-11-21 15:00:00	SPY	ETF	310.71	310.75	310.47	310.5	2582850.0
2019-11-21 15:30:00	SPY	ETF	310.505	310.6	309.88	310.29	11222476.0
2019-11-21 16:00:00	SPY	ETF	310.29	310.57	310.13	310.44	6968166.0
2019-11-21 16:30:00	SPY	ETF	310.42	310.49	310.27	310.46	852319.0
2019-11-21 17:00:00	SPY	ETF	310.48	310.5	310.4	310.4	38590.0
2019-11-21 17:30:00	SPY	ETF	310.4	310.43	310.25	310.37	135113.0
2019-11-21 18:00:00	SPY	ETF	310.4	310.46	310.3	310.46	59456.0
2019-11-21 18:30:00	SPY	ETF	310.46	310.46	310.19	310.19	16405.0
2019-11-21 19:00:00	SPY	ETF	310.2	310.35	310.1	310.33	12091.0
2019-11-21 19:30:00	SPY	ETF	310.33	310.68	310.33	310.57	45093.0
2019-11-21 04:00:00	QQQ	ETF	201.67	201.77	201.0	201.66	14979.0
2019-11-21 04:30:00	QQQ	ETF	201.73	201.78	201.7	201.7	1850.0
2019-11-21 05:00:00	QQQ	ETF	201.72	202.33	201.72	202.15	9254.0
2019-11-21 05:30:00	QQQ	ETF	202.1	202.11	201.9	201.93	6073.0
2019-11-21 06:00:00	QQQ	ETF	201.89	201.9	201.82	201.9	1500.0
2019-11-21 06:30:00	QQQ	ETF	201.99	202.07	201.99	202.07	6906.0
2019-11-21 07:00:00	QQQ	ETF	202.03	202.06	201.8	201.86	24610.0
2019-11-21 07:30:00	QQQ	ETF	201.87	201.98	201.8	201.96	29094.0
2019-11-21 08:00:00	QQQ	ETF	202.01	202.51	201.8602	202.4	146440.0
2019-11-21 08:30:00	QQQ	ETF	202.35	202.36	202.06	202.1	72119.0
2019-11-21 09:00:00	QQQ	ETF	202.1	202.21	201.83	201.91	77298.0
2019-11-21 09:30:00	QQQ	ETF	201.94	201.9992	201.41	201.68	2112768.0
2019-11-21 10:00:00	QQQ	ETF	201.69	202.04	201.2239	201.35	2098519.0
2019-11-21 10:30:00	QQQ	ETF	201.32	201.58	201.1	201.52	1450307.0
2019-11-21 11:00:00	QQQ	ETF	201.52	201.81	201.45	201.5	941530.0
2019-11-21 11:30:00	QQQ	ETF	201.47	201.57	201.1	201.125	625938.0
2019-11-21 12:00:00	QQQ	ETF	201.12	201.45	201.07	201.3951	568344.0
2019-11-21 12:30:00	QQQ	ETF	201.395	201.649	201.35	201.61	539852.0

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

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