PREVIEW / etf_30min / 2021-03-26

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-03-26.parquet
  size:    612 KB
  rows:    23,529

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
2021-03-26 04:00:00	SPY	ETF	390.74	391.37	390.74	390.86	45330.0
2021-03-26 04:30:00	SPY	ETF	390.85	391.04	390.76	390.85	12800.0
2021-03-26 05:00:00	SPY	ETF	390.84	390.84	390.5	390.69	7300.0
2021-03-26 05:30:00	SPY	ETF	390.7	390.81	390.62	390.81	5500.0
2021-03-26 06:00:00	SPY	ETF	390.69	390.9	390.53	390.64	3310.0
2021-03-26 06:30:00	SPY	ETF	390.6	390.6	390.26	390.58	10644.0
2021-03-26 07:00:00	SPY	ETF	390.55	390.74	390.08	390.08	93594.0
2021-03-26 07:30:00	SPY	ETF	390.08	391.03	390.08	390.61	186282.0
2021-03-26 08:00:00	SPY	ETF	390.5999	391.5	390.01	390.12	286414.0
2021-03-26 08:30:00	SPY	ETF	390.09	390.99	390.09	390.65	159724.0
2021-03-26 09:00:00	SPY	ETF	390.61	391.04	390.46	390.96	260106.0
2021-03-26 09:30:00	SPY	ETF	390.93	391.39	390.84	391.28	5878152.0
2021-03-26 10:00:00	SPY	ETF	391.27	392.06	391.06	392.06	4778590.0
2021-03-26 10:30:00	SPY	ETF	392.05	392.35	391.39	391.51	4790055.0
2021-03-26 11:00:00	SPY	ETF	391.52	391.82	390.58	390.99	4564446.0
2021-03-26 11:30:00	SPY	ETF	390.99	391.93	390.74	391.8719	3390921.0
2021-03-26 12:00:00	SPY	ETF	391.88	392.19	391.52	392.14	2594922.0
2021-03-26 12:30:00	SPY	ETF	392.15	392.9411	392.05	392.4808	2694009.0
2021-03-26 13:00:00	SPY	ETF	392.4896	392.99	392.48	392.81	2022335.0
2021-03-26 13:30:00	SPY	ETF	392.81	392.92	391.36	391.98	3850757.0
2021-03-26 14:00:00	SPY	ETF	391.97	392.12	390.3301	391.5285	5816027.0
2021-03-26 14:30:00	SPY	ETF	391.53	392.29	390.29	392.25	6313695.0
2021-03-26 15:00:00	SPY	ETF	392.24	392.87	391.83	392.82	5897676.0
2021-03-26 15:30:00	SPY	ETF	392.82	396.41	392.82	395.94	21131706.0
2021-03-26 16:00:00	SPY	ETF	395.94	396.25	390.9	395.92	6654090.0
2021-03-26 16:30:00	SPY	ETF	395.95	396.09	392.9782	395.85	2298297.0
2021-03-26 17:00:00	SPY	ETF	395.89	395.98	395.51	395.7	166263.0
2021-03-26 17:30:00	SPY	ETF	395.62	395.76	395.59	395.59	36850.0
2021-03-26 18:00:00	SPY	ETF	395.56	403.9	395.53	395.61	1270053.0
2021-03-26 18:30:00	SPY	ETF	395.98	395.98	395.41	395.5	30823.0
2021-03-26 19:00:00	SPY	ETF	395.5	395.56	395.41	395.42	16122.0
2021-03-26 19:30:00	SPY	ETF	395.49	395.72	395.45	395.63	41303.0
2021-03-26 04:00:00	QQQ	ETF	312.57	312.8	312.36	312.47	33016.0
2021-03-26 04:30:00	QQQ	ETF	312.32	312.7	312.09	312.17	19175.0
2021-03-26 05:00:00	QQQ	ETF	312.25	312.41	311.75	312.12	37942.0
2021-03-26 05:30:00	QQQ	ETF	312.11	312.37	312.01	312.37	10990.0
2021-03-26 06:00:00	QQQ	ETF	312.4	312.66	312.04	312.16	26349.0
2021-03-26 06:30:00	QQQ	ETF	312.08	312.1	311.44	311.44	48243.0
2021-03-26 07:00:00	QQQ	ETF	311.44	311.69	310.0	310.04	194386.0
2021-03-26 07:30:00	QQQ	ETF	310.04	310.72	309.89	310.5	288930.0
2021-03-26 08:00:00	QQQ	ETF	312.58	313.89	309.02	309.51	355167.0
2021-03-26 08:30:00	QQQ	ETF	309.49	310.96	309.41	310.65	265783.0
2021-03-26 09:00:00	QQQ	ETF	310.6	311.27	310.53	311.14	170967.0
2021-03-26 09:30:00	QQQ	ETF	311.1	312.74	310.9	312.23	5458274.0
2021-03-26 10:00:00	QQQ	ETF	312.24	313.37	311.47	312.67	3713912.0
2021-03-26 10:30:00	QQQ	ETF	312.68	313.58	312.16	312.38	2913780.0
2021-03-26 11:00:00	QQQ	ETF	312.42	312.7387	311.0	311.37	3384813.0
2021-03-26 11:30:00	QQQ	ETF	311.37	312.96	311.03	312.96	2691913.0
2021-03-26 12:00:00	QQQ	ETF	312.96	313.17	312.15	312.86	2141125.0
2021-03-26 12:30:00	QQQ	ETF	312.88	313.54	312.61	312.71	2056485.0

> showing 50 of 23,529 rows — these rows as CSV

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