PREVIEW / etf_30min / 2020-08-24

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-08-24.parquet
  size:    559 KB
  rows:    20,874

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-24 04:00:00	SPY	ETF	341.2	341.5	341.2	341.38	29864.0
2020-08-24 04:30:00	SPY	ETF	341.37	341.82	341.37	341.72	17264.0
2020-08-24 05:00:00	SPY	ETF	341.7	341.74	341.54	341.7	6774.0
2020-08-24 05:30:00	SPY	ETF	341.67	341.86	341.65	341.82	6578.0
2020-08-24 06:00:00	SPY	ETF	341.75	341.84	341.65	341.82	6723.0
2020-08-24 06:30:00	SPY	ETF	341.83	342.2	341.83	342.12	36890.0
2020-08-24 07:00:00	SPY	ETF	342.16	342.29	342.04	342.28	170209.0
2020-08-24 07:30:00	SPY	ETF	342.22	342.4	342.2	342.35	158584.0
2020-08-24 08:00:00	SPY	ETF	342.39	342.48	340.59	342.14	213550.0
2020-08-24 08:30:00	SPY	ETF	342.15	342.3	342.03	342.15	120776.0
2020-08-24 09:00:00	SPY	ETF	342.17	342.33	342.08	342.14	113949.0
2020-08-24 09:30:00	SPY	ETF	342.12	342.24	341.525	341.875	6161067.0
2020-08-24 10:00:00	SPY	ETF	341.88	342.41	341.35	342.06	3490592.0
2020-08-24 10:30:00	SPY	ETF	342.0582	342.29	341.06	341.31	4512331.0
2020-08-24 11:00:00	SPY	ETF	341.29	341.86	341.175	341.42	1657507.0
2020-08-24 11:30:00	SPY	ETF	341.42	341.98	341.37	341.77	3434692.0
2020-08-24 12:00:00	SPY	ETF	341.78	342.07	341.67	341.71	1564829.0
2020-08-24 12:30:00	SPY	ETF	341.715	341.93	341.6	341.691	1030241.0
2020-08-24 13:00:00	SPY	ETF	341.69	342.0564	341.66	341.81	1290432.0
2020-08-24 13:30:00	SPY	ETF	341.815	341.87	341.5	341.77	1327223.0
2020-08-24 14:00:00	SPY	ETF	341.78	341.98	341.64	341.78	1582587.0
2020-08-24 14:30:00	SPY	ETF	341.77	341.79	341.29	341.51	2015854.0
2020-08-24 15:00:00	SPY	ETF	341.51	341.92	341.14	341.915	2292626.0
2020-08-24 15:30:00	SPY	ETF	341.9123	343.0	341.8	342.94	8538315.0
2020-08-24 16:00:00	SPY	ETF	342.95	342.97	341.9286	342.8	7119818.0
2020-08-24 16:30:00	SPY	ETF	342.85	342.92	342.61	342.73	246217.0
2020-08-24 17:00:00	SPY	ETF	342.77	342.92	342.71	342.8	33632.0
2020-08-24 17:30:00	SPY	ETF	342.8	342.81	342.75	342.79	21997.0
2020-08-24 18:00:00	SPY	ETF	342.79	342.89	342.77	342.83	82137.0
2020-08-24 18:30:00	SPY	ETF	342.83	342.92	342.82	342.9	27395.0
2020-08-24 19:00:00	SPY	ETF	342.92	342.97	342.8	342.81	26725.0
2020-08-24 19:30:00	SPY	ETF	342.8	343.43	342.8	343.39	58349.0
2020-08-24 04:00:00	QQQ	ETF	284.08	284.65	284.08	284.49	39990.0
2020-08-24 04:30:00	QQQ	ETF	284.56	284.84	284.56	284.74	17478.0
2020-08-24 05:00:00	QQQ	ETF	284.79	284.79	284.59	284.75	7447.0
2020-08-24 05:30:00	QQQ	ETF	284.7	284.76	284.5	284.5	7021.0
2020-08-24 06:00:00	QQQ	ETF	284.57	284.57	284.34	284.47	13675.0
2020-08-24 06:30:00	QQQ	ETF	284.57	284.72	284.54	284.58	76501.0
2020-08-24 07:00:00	QQQ	ETF	284.58	284.74	284.46	284.65	143603.0
2020-08-24 07:30:00	QQQ	ETF	284.68	285.0	284.61	285.0	53985.0
2020-08-24 08:00:00	QQQ	ETF	285.1	285.24	283.4	284.97	248203.0
2020-08-24 08:30:00	QQQ	ETF	284.98	285.33	284.85	285.13	133050.0
2020-08-24 09:00:00	QQQ	ETF	285.1	285.29	285.04	285.18	145744.0
2020-08-24 09:30:00	QQQ	ETF	285.14	286.0	283.33	284.335	5605892.0
2020-08-24 10:00:00	QQQ	ETF	284.37	284.59	282.78	283.79	4184442.0
2020-08-24 10:30:00	QQQ	ETF	283.78	283.85	281.27	281.7	3568438.0
2020-08-24 11:00:00	QQQ	ETF	281.7	283.17	281.5	281.99	2081810.0
2020-08-24 11:30:00	QQQ	ETF	282.01	283.54	281.9899	283.359	2075433.0
2020-08-24 12:00:00	QQQ	ETF	283.355	284.0	283.24	283.3289	1038710.0
2020-08-24 12:30:00	QQQ	ETF	283.32	283.52	282.91	283.13	869925.0

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

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