PREVIEW / etf_30min / 2020-08-26

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-08-26.parquet
  size:    561 KB
  rows:    20,708

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
2020-08-26 04:00:00	SPY	ETF	344.4	344.51	344.14	344.5	9025.0
2020-08-26 04:30:00	SPY	ETF	344.56	344.7	344.48	344.48	5530.0
2020-08-26 05:00:00	SPY	ETF	344.49	344.6	344.49	344.55	6011.0
2020-08-26 05:30:00	SPY	ETF	344.45	344.45	344.25	344.32	17670.0
2020-08-26 06:00:00	SPY	ETF	344.32	344.45	344.26	344.35	9144.0
2020-08-26 06:30:00	SPY	ETF	344.34	344.5	344.33	344.5	10924.0
2020-08-26 07:00:00	SPY	ETF	344.52	344.62	344.35	344.59	34351.0
2020-08-26 07:30:00	SPY	ETF	344.54	344.65	344.3	344.35	126151.0
2020-08-26 08:00:00	SPY	ETF	344.6201	344.6299	344.05	344.47	93955.0
2020-08-26 08:30:00	SPY	ETF	344.53	344.55	344.34	344.46	118814.0
2020-08-26 09:00:00	SPY	ETF	344.43	344.99	344.43	344.73	382900.0
2020-08-26 09:30:00	SPY	ETF	344.76	344.8	344.17	344.66	3809013.0
2020-08-26 10:00:00	SPY	ETF	344.675	344.91	344.45	344.9	2712644.0
2020-08-26 10:30:00	SPY	ETF	344.9	345.33	344.86	345.24	2468855.0
2020-08-26 11:00:00	SPY	ETF	345.24	345.47	345.08	345.45	1819595.0
2020-08-26 11:30:00	SPY	ETF	345.44	346.089	345.37	345.995	2956936.0
2020-08-26 12:00:00	SPY	ETF	345.993	347.025	345.895	346.87	2819858.0
2020-08-26 12:30:00	SPY	ETF	346.88	346.95	346.3136	346.61	3240187.0
2020-08-26 13:00:00	SPY	ETF	346.6083	347.0	346.6	346.683	3081747.0
2020-08-26 13:30:00	SPY	ETF	346.69	347.03	346.6501	347.02	2915670.0
2020-08-26 14:00:00	SPY	ETF	347.0267	347.86	346.95	347.784	2736036.0
2020-08-26 14:30:00	SPY	ETF	347.789	347.83	346.36	346.53	3950502.0
2020-08-26 15:00:00	SPY	ETF	346.5367	347.74	346.3	347.72	4342181.0
2020-08-26 15:30:00	SPY	ETF	347.72	347.81	347.17	347.56	6963144.0
2020-08-26 16:00:00	SPY	ETF	347.55	348.15	346.8321	347.98	4431462.0
2020-08-26 16:30:00	SPY	ETF	348.0	348.36	347.57	348.08	483120.0
2020-08-26 17:00:00	SPY	ETF	348.07	348.07	347.95	347.97	98026.0
2020-08-26 17:30:00	SPY	ETF	347.97	347.97	347.91	347.95	21902.0
2020-08-26 18:00:00	SPY	ETF	347.99	348.05	347.52	347.6	75492.0
2020-08-26 18:30:00	SPY	ETF	347.57	347.77	347.5	347.6099	26944.0
2020-08-26 19:00:00	SPY	ETF	347.63	347.73	347.59	347.61	26684.0
2020-08-26 19:30:00	SPY	ETF	347.57	347.89	347.53	347.77	45491.0
2020-08-26 04:00:00	QQQ	ETF	286.47	286.83	286.29	286.68	28127.0
2020-08-26 04:30:00	QQQ	ETF	286.64	287.03	286.64	286.93	15419.0
2020-08-26 05:00:00	QQQ	ETF	286.98	287.13	286.94	286.95	11040.0
2020-08-26 05:30:00	QQQ	ETF	286.93	286.93	286.72	286.78	6573.0
2020-08-26 06:00:00	QQQ	ETF	286.83	287.04	286.75	286.99	9320.0
2020-08-26 06:30:00	QQQ	ETF	286.96	287.23	286.91	287.23	15229.0
2020-08-26 07:00:00	QQQ	ETF	287.17	287.39	287.1	287.33	66585.0
2020-08-26 07:30:00	QQQ	ETF	287.31	287.47	287.02	287.1	100105.0
2020-08-26 08:00:00	QQQ	ETF	287.4301	287.4301	286.24	286.72	255287.0
2020-08-26 08:30:00	QQQ	ETF	286.73	286.75	286.32	286.69	242704.0
2020-08-26 09:00:00	QQQ	ETF	286.742	287.13	286.72	287.11	322598.0
2020-08-26 09:30:00	QQQ	ETF	287.11	287.8	286.965	287.55	3474414.0
2020-08-26 10:00:00	QQQ	ETF	287.55	288.1	287.18	288.01	2925868.0
2020-08-26 10:30:00	QQQ	ETF	288.03	288.91	287.9921	288.78	1994064.0
2020-08-26 11:00:00	QQQ	ETF	288.79	289.34	288.73	289.31	1729097.0
2020-08-26 11:30:00	QQQ	ETF	289.305	290.24	289.28	290.09	2035029.0
2020-08-26 12:00:00	QQQ	ETF	290.08	291.52	289.79	291.3016	2527621.0
2020-08-26 12:30:00	QQQ	ETF	291.31	291.41	290.19	290.38	2113132.0

> showing 50 of 20,708 rows — these rows as CSV

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