PREVIEW / etf_30min / 2019-10-22

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-10-22.parquet
  size:    505 KB
  rows:    17,472

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-10-22 04:00:00	SPY	ETF	299.95	299.95	299.68	299.68	5514.0
2019-10-22 04:30:00	SPY	ETF	299.7	299.85	299.55	299.85	12550.0
2019-10-22 05:00:00	SPY	ETF	299.85	300.05	299.85	300.05	4990.0
2019-10-22 05:30:00	SPY	ETF	300.09	300.19	300.07	300.15	6240.0
2019-10-22 06:00:00	SPY	ETF	300.2	300.22	300.04	300.07	12225.0
2019-10-22 06:30:00	SPY	ETF	300.05	300.2	299.98	300.2	16597.0
2019-10-22 07:00:00	SPY	ETF	300.25	300.31	300.18	300.26	75747.0
2019-10-22 07:30:00	SPY	ETF	300.28	300.49	300.28	300.48	76622.0
2019-10-22 08:00:00	SPY	ETF	300.2301	300.65	299.85	300.55	190336.0
2019-10-22 08:30:00	SPY	ETF	300.56	300.69	300.49	300.54	146126.0
2019-10-22 09:00:00	SPY	ETF	300.55	300.7298	300.46	300.55	159542.0
2019-10-22 09:30:00	SPY	ETF	300.58	300.8	300.315	300.67	3162079.0
2019-10-22 10:00:00	SPY	ETF	300.68	300.84	300.25	300.54	2431620.0
2019-10-22 10:30:00	SPY	ETF	300.525	300.89	300.39	300.655	3583652.0
2019-10-22 11:00:00	SPY	ETF	300.66	300.89	300.42	300.44	2097545.0
2019-10-22 11:30:00	SPY	ETF	300.4483	300.71	300.17	300.29	2589311.0
2019-10-22 12:00:00	SPY	ETF	300.29	300.81	300.22	300.79	2524099.0
2019-10-22 12:30:00	SPY	ETF	300.78	300.9	300.68	300.7551	1682670.0
2019-10-22 13:00:00	SPY	ETF	300.76	300.79	300.54	300.63	2199078.0
2019-10-22 13:30:00	SPY	ETF	300.63	300.78	300.33	300.5	3944679.0
2019-10-22 14:00:00	SPY	ETF	300.495	300.77	300.34	300.51	4408201.0
2019-10-22 14:30:00	SPY	ETF	300.505	300.58	299.45	299.68	4661168.0
2019-10-22 15:00:00	SPY	ETF	299.68	299.87	299.22	299.84	3763482.0
2019-10-22 15:30:00	SPY	ETF	299.84	299.97	298.91	299.03	7345849.0
2019-10-22 16:00:00	SPY	ETF	299.02	299.814	298.75	298.89	2618079.0
2019-10-22 16:30:00	SPY	ETF	298.86	299.01	298.31	298.55	395785.0
2019-10-22 17:00:00	SPY	ETF	298.48	298.6	298.43	298.43	22255.0
2019-10-22 17:30:00	SPY	ETF	298.59	299.01	298.52	298.55	28899.0
2019-10-22 18:00:00	SPY	ETF	298.64	299.01	298.57	298.8	53343.0
2019-10-22 18:30:00	SPY	ETF	298.86	298.86	298.75	298.75	7268.0
2019-10-22 19:00:00	SPY	ETF	298.82	298.84	298.65	298.66	11553.0
2019-10-22 19:30:00	SPY	ETF	298.63	298.7	298.53	298.59	23232.0
2019-10-22 04:00:00	QQQ	ETF	193.32	193.36	193.14	193.14	7346.0
2019-10-22 04:30:00	QQQ	ETF	193.22	193.34	193.22	193.34	1000.0
2019-10-22 05:00:00	QQQ	ETF	193.41	193.52	193.41	193.52	4950.0
2019-10-22 05:30:00	QQQ	ETF	193.52	193.64	193.52	193.61	500.0
2019-10-22 06:00:00	QQQ	ETF	193.61	193.61	193.51	193.54	6715.0
2019-10-22 06:30:00	QQQ	ETF	193.54	193.8	193.52	193.8	9540.0
2019-10-22 07:00:00	QQQ	ETF	193.78	193.8	193.69	193.79	20961.0
2019-10-22 07:30:00	QQQ	ETF	193.79	194.04	193.79	194.04	45452.0
2019-10-22 08:00:00	QQQ	ETF	193.7199	194.18	193.39	194.1	51687.0
2019-10-22 08:30:00	QQQ	ETF	194.14	194.18	194.01	194.05	27375.0
2019-10-22 09:00:00	QQQ	ETF	194.05	194.14	193.95	194.01	57233.0
2019-10-22 09:30:00	QQQ	ETF	194.06	194.42	193.75	193.99	1834833.0
2019-10-22 10:00:00	QQQ	ETF	193.995	194.1499	193.66	193.81	982813.0
2019-10-22 10:30:00	QQQ	ETF	193.8	193.99	193.66	193.68	744356.0
2019-10-22 11:00:00	QQQ	ETF	193.66	193.76	193.06	193.1149	1116511.0
2019-10-22 11:30:00	QQQ	ETF	193.11	193.31	192.7751	192.8644	878279.0
2019-10-22 12:00:00	QQQ	ETF	192.865	193.26	192.8	193.22	565050.0
2019-10-22 12:30:00	QQQ	ETF	193.22	193.32	193.1	193.26	692085.0

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

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