PREVIEW / etf_30min / 2019-09-11

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-09-11.parquet
  size:    516 KB
  rows:    17,969

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-09-11 04:00:00	SPY	ETF	298.58	298.64	298.18	298.2	2009.0
2019-09-11 04:30:00	SPY	ETF	298.19	298.42	298.19	298.3	1840.0
2019-09-11 05:00:00	SPY	ETF	298.0	298.12	297.77	297.86	5100.0
2019-09-11 05:30:00	SPY	ETF	297.97	298.13	297.87	298.13	4320.0
2019-09-11 06:00:00	SPY	ETF	298.14	298.24	298.04	298.17	1825.0
2019-09-11 06:30:00	SPY	ETF	298.19	298.34	298.0	298.09	49588.0
2019-09-11 07:00:00	SPY	ETF	298.05	298.34	298.05	298.34	81585.0
2019-09-11 07:30:00	SPY	ETF	298.27	298.68	298.18	298.6	177539.0
2019-09-11 08:00:00	SPY	ETF	298.12	298.8	298.07	298.6	199424.0
2019-09-11 08:30:00	SPY	ETF	298.54	298.58	298.4	298.54	162132.0
2019-09-11 09:00:00	SPY	ETF	298.54	298.54	298.1972	298.47	208732.0
2019-09-11 09:30:00	SPY	ETF	298.47	298.95	297.75	298.57	6976315.0
2019-09-11 10:00:00	SPY	ETF	298.59	299.05	298.5	298.91	4040373.0
2019-09-11 10:30:00	SPY	ETF	298.91	299.1	298.78	299.06	3765064.0
2019-09-11 11:00:00	SPY	ETF	299.07	299.18	298.91	299.05	3737370.0
2019-09-11 11:30:00	SPY	ETF	299.06	299.44	299.06	299.43	3493423.0
2019-09-11 12:00:00	SPY	ETF	299.43	299.71	299.43	299.49	3813611.0
2019-09-11 12:30:00	SPY	ETF	299.49	299.9	299.47	299.72	4026126.0
2019-09-11 13:00:00	SPY	ETF	299.725	299.92	299.64	299.73	3448787.0
2019-09-11 13:30:00	SPY	ETF	299.725	299.87	299.54	299.595	2774403.0
2019-09-11 14:00:00	SPY	ETF	299.59	299.63	299.42	299.4908	3101937.0
2019-09-11 14:30:00	SPY	ETF	299.5	299.53	299.3	299.46	1965768.0
2019-09-11 15:00:00	SPY	ETF	299.45	299.77	299.44	299.69	2996457.0
2019-09-11 15:30:00	SPY	ETF	299.685	300.34	299.56	300.29	11521790.0
2019-09-11 16:00:00	SPY	ETF	300.3	300.48	300.16	300.41	9305687.0
2019-09-11 16:30:00	SPY	ETF	300.41	300.67	300.25	300.48	995982.0
2019-09-11 17:00:00	SPY	ETF	300.48	300.51	300.43	300.46	43274.0
2019-09-11 17:30:00	SPY	ETF	300.48	300.53	300.46	300.47	30593.0
2019-09-11 18:00:00	SPY	ETF	300.49	300.56	300.49	300.52	335143.0
2019-09-11 18:30:00	SPY	ETF	300.51	300.51	300.41	300.43	22844.0
2019-09-11 19:00:00	SPY	ETF	300.47	302.2	300.41	301.88	247626.0
2019-09-11 19:30:00	SPY	ETF	301.83	302.15	301.7	302.05	197916.0
2019-09-11 04:00:00	QQQ	ETF	191.03	191.15	190.77	190.77	11385.0
2019-09-11 04:30:00	QQQ	ETF	190.8	191.0	190.8	190.92	9900.0
2019-09-11 05:00:00	QQQ	ETF	190.56	190.56	190.08	190.39	17500.0
2019-09-11 05:30:00	QQQ	ETF	190.45	190.55	190.26	190.54	9499.0
2019-09-11 06:00:00	QQQ	ETF	190.58	190.73	190.57	190.61	10275.0
2019-09-11 06:30:00	QQQ	ETF	190.59	190.72	190.43	190.48	6150.0
2019-09-11 07:00:00	QQQ	ETF	190.49	190.87	190.45	190.8	147949.0
2019-09-11 07:30:00	QQQ	ETF	190.78	191.18	190.76	191.11	107226.0
2019-09-11 08:00:00	QQQ	ETF	190.5899	191.25	190.55	191.03	72741.0
2019-09-11 08:30:00	QQQ	ETF	191.04	191.06	190.91	191.03	99724.0
2019-09-11 09:00:00	QQQ	ETF	191.0	191.11	190.93	190.96	371088.0
2019-09-11 09:30:00	QQQ	ETF	190.96	191.57	190.56	191.42	3259354.0
2019-09-11 10:00:00	QQQ	ETF	191.42	191.91	191.335	191.76	2230936.0
2019-09-11 10:30:00	QQQ	ETF	191.75	191.97	191.62	191.76	891424.0
2019-09-11 11:00:00	QQQ	ETF	191.77	191.9399	191.64	191.83	1016810.0
2019-09-11 11:30:00	QQQ	ETF	191.835	192.22	191.835	192.18	1202206.0
2019-09-11 12:00:00	QQQ	ETF	192.18	192.47	192.18	192.2567	1043866.0
2019-09-11 12:30:00	QQQ	ETF	192.255	192.52	192.2346	192.33	1027122.0

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

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