PREVIEW / etf_30min / 2020-08-28

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-08-28.parquet
  size:    549 KB
  rows:    20,298

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-28 04:00:00	SPY	ETF	349.26	350.07	349.26	349.93	30501.0
2020-08-28 04:30:00	SPY	ETF	349.9	349.92	349.66	349.92	6269.0
2020-08-28 05:00:00	SPY	ETF	349.79	350.07	349.56	349.78	8678.0
2020-08-28 05:30:00	SPY	ETF	349.55	349.91	349.55	349.88	23757.0
2020-08-28 06:00:00	SPY	ETF	349.89	349.89	349.0	349.2	21101.0
2020-08-28 06:30:00	SPY	ETF	349.31	349.53	349.28	349.41	7243.0
2020-08-28 07:00:00	SPY	ETF	349.4	349.82	349.4	349.73	48183.0
2020-08-28 07:30:00	SPY	ETF	349.81	349.97	349.55	349.89	51210.0
2020-08-28 08:00:00	SPY	ETF	349.8601	350.58	348.89	349.82	106317.0
2020-08-28 08:30:00	SPY	ETF	349.86	349.86	349.3	349.36	106665.0
2020-08-28 09:00:00	SPY	ETF	349.35	349.68	349.35	349.39	153609.0
2020-08-28 09:30:00	SPY	ETF	349.44	349.58	348.61	349.29	4102253.0
2020-08-28 10:00:00	SPY	ETF	349.295	349.35	348.56	348.8599	3438152.0
2020-08-28 10:30:00	SPY	ETF	348.86	349.1299	348.15	348.4	3085653.0
2020-08-28 11:00:00	SPY	ETF	348.41	349.319	348.26	349.2	3643263.0
2020-08-28 11:30:00	SPY	ETF	349.1886	349.44	349.01	349.3	1215779.0
2020-08-28 12:00:00	SPY	ETF	349.29	349.52	349.17	349.2276	1987286.0
2020-08-28 12:30:00	SPY	ETF	349.23	349.71	349.07	349.67	1521416.0
2020-08-28 13:00:00	SPY	ETF	349.68	349.68	348.805	348.805	3097787.0
2020-08-28 13:30:00	SPY	ETF	348.82	349.42	348.75	349.25	1963617.0
2020-08-28 14:00:00	SPY	ETF	349.26	349.555	348.994	349.505	1902714.0
2020-08-28 14:30:00	SPY	ETF	349.5	349.92	349.34	349.78	2532704.0
2020-08-28 15:00:00	SPY	ETF	349.7777	350.6077	349.69	350.39	4548674.0
2020-08-28 15:30:00	SPY	ETF	350.39	350.72	350.24	350.54	8744642.0
2020-08-28 16:00:00	SPY	ETF	350.53	350.67	348.2234	350.5	2574749.0
2020-08-28 16:30:00	SPY	ETF	350.47	350.72	350.39	350.67	244180.0
2020-08-28 17:00:00	SPY	ETF	350.61	350.77	350.58	350.74	310059.0
2020-08-28 17:30:00	SPY	ETF	350.72	350.84	350.72	350.8	62775.0
2020-08-28 18:00:00	SPY	ETF	350.79	351.0	350.78	351.0	53574.0
2020-08-28 18:30:00	SPY	ETF	351.0	351.07	350.92	350.94	26709.0
2020-08-28 19:00:00	SPY	ETF	350.94	350.99	350.88	350.99	9689.0
2020-08-28 19:30:00	SPY	ETF	350.95	351.03	350.9	350.98	25715.0
2020-08-28 04:00:00	QQQ	ETF	291.6	291.9	291.46	291.78	19580.0
2020-08-28 04:30:00	QQQ	ETF	291.69	291.69	291.33	291.33	11400.0
2020-08-28 05:00:00	QQQ	ETF	291.36	291.6	291.17	291.45	6483.0
2020-08-28 05:30:00	QQQ	ETF	291.46	291.63	291.36	291.48	9188.0
2020-08-28 06:00:00	QQQ	ETF	291.45	291.47	290.82	291.08	21142.0
2020-08-28 06:30:00	QQQ	ETF	291.19	291.36	291.15	291.2	21038.0
2020-08-28 07:00:00	QQQ	ETF	291.42	291.95	291.4	291.8	85660.0
2020-08-28 07:30:00	QQQ	ETF	291.92	292.2	291.74	292.1	62128.0
2020-08-28 08:00:00	QQQ	ETF	292.1	293.3	290.95	291.81	92099.0
2020-08-28 08:30:00	QQQ	ETF	291.8	291.9	291.46	291.85	132928.0
2020-08-28 09:00:00	QQQ	ETF	291.83	292.39	291.83	292.26	122886.0
2020-08-28 09:30:00	QQQ	ETF	292.27	292.88	291.47	292.88	3091993.0
2020-08-28 10:00:00	QQQ	ETF	292.875	293.18	292.155	292.86	2140576.0
2020-08-28 10:30:00	QQQ	ETF	292.855	292.96	291.465	291.7	2149337.0
2020-08-28 11:00:00	QQQ	ETF	291.7	292.785	291.45	292.68	1393321.0
2020-08-28 11:30:00	QQQ	ETF	292.6676	292.83	292.21	292.5827	1035339.0
2020-08-28 12:00:00	QQQ	ETF	292.59	292.8399	292.14	292.21	833190.0
2020-08-28 12:30:00	QQQ	ETF	292.22	292.33	291.8	292.27	1349533.0

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

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