PREVIEW / etf_30min / 2021-02-05

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-02-05.parquet
  size:    621 KB
  rows:    23,617

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-02-05 04:00:00	SPY	ETF	387.06	387.2	386.88	387.15	13432.0
2021-02-05 04:30:00	SPY	ETF	387.21	387.66	387.21	387.47	26798.0
2021-02-05 05:00:00	SPY	ETF	387.46	387.73	387.46	387.56	9330.0
2021-02-05 05:30:00	SPY	ETF	387.57	387.98	387.57	387.78	7918.0
2021-02-05 06:00:00	SPY	ETF	387.97	388.24	387.97	388.15	27340.0
2021-02-05 06:30:00	SPY	ETF	387.97	388.15	387.89	388.14	13132.0
2021-02-05 07:00:00	SPY	ETF	388.11	388.12	387.9	387.999	88811.0
2021-02-05 07:30:00	SPY	ETF	387.97	387.98	387.72	387.8	52328.0
2021-02-05 08:00:00	SPY	ETF	387.8	388.09	386.81	387.75	127111.0
2021-02-05 08:30:00	SPY	ETF	387.55	387.97	387.35	387.55	205495.0
2021-02-05 09:00:00	SPY	ETF	387.7	388.26	386.19	388.24	410017.0
2021-02-05 09:30:00	SPY	ETF	388.21	388.29	387.042	387.14	4347117.0
2021-02-05 10:00:00	SPY	ETF	387.15	387.42	386.485	387.155	3331601.0
2021-02-05 10:30:00	SPY	ETF	387.15	387.98	387.0	387.695	2299243.0
2021-02-05 11:00:00	SPY	ETF	387.69	387.855	387.11	387.35	1719849.0
2021-02-05 11:30:00	SPY	ETF	387.3519	387.78	387.2913	387.32	1362166.0
2021-02-05 12:00:00	SPY	ETF	387.315	387.91	387.18	387.87	1008108.0
2021-02-05 12:30:00	SPY	ETF	387.87	388.46	387.78	388.4378	1469471.0
2021-02-05 13:00:00	SPY	ETF	388.4396	388.47	387.98	388.05	1220201.0
2021-02-05 13:30:00	SPY	ETF	388.05	388.1099	387.563	387.5854	1278045.0
2021-02-05 14:00:00	SPY	ETF	387.5978	387.91	387.41	387.85	1258237.0
2021-02-05 14:30:00	SPY	ETF	387.8425	388.03	387.32	387.51	1312139.0
2021-02-05 15:00:00	SPY	ETF	387.52	387.71	387.19	387.21	2190432.0
2021-02-05 15:30:00	SPY	ETF	387.21	387.81	387.18	387.68	5609925.0
2021-02-05 16:00:00	SPY	ETF	387.67	388.1	387.58	388.03	3348819.0
2021-02-05 16:30:00	SPY	ETF	388.01	388.15	387.94	388.07	318893.0
2021-02-05 17:00:00	SPY	ETF	388.04	388.06	387.75	388.02	104664.0
2021-02-05 17:30:00	SPY	ETF	388.02	388.2	387.7	388.0	78373.0
2021-02-05 18:00:00	SPY	ETF	388.03	388.11	388.0	388.1	3542.0
2021-02-05 18:30:00	SPY	ETF	388.11	388.17	388.0	388.0	15492.0
2021-02-05 19:00:00	SPY	ETF	388.08	388.17	388.02	388.09	4022.0
2021-02-05 19:30:00	SPY	ETF	388.07	388.3	388.01	388.19	18937.0
2021-02-05 04:00:00	QQQ	ETF	331.16	331.16	330.76	330.93	24645.0
2021-02-05 04:30:00	QQQ	ETF	330.91	331.39	330.91	331.18	16041.0
2021-02-05 05:00:00	QQQ	ETF	331.15	331.37	331.06	331.14	20903.0
2021-02-05 05:30:00	QQQ	ETF	331.07	331.49	331.07	331.29	27293.0
2021-02-05 06:00:00	QQQ	ETF	331.33	331.6	331.03	331.18	39594.0
2021-02-05 06:30:00	QQQ	ETF	331.15	331.5	331.15	331.38	7500.0
2021-02-05 07:00:00	QQQ	ETF	331.44	331.6	331.309	331.47	51472.0
2021-02-05 07:30:00	QQQ	ETF	331.41	331.53	331.27	331.3	40432.0
2021-02-05 08:00:00	QQQ	ETF	331.33	332.05	330.24	330.94	237658.0
2021-02-05 08:30:00	QQQ	ETF	330.9	331.64	330.75	331.09	237498.0
2021-02-05 09:00:00	QQQ	ETF	331.03	331.42	330.9	331.25	81185.0
2021-02-05 09:30:00	QQQ	ETF	331.22	331.31	329.93	330.03	2733886.0
2021-02-05 10:00:00	QQQ	ETF	329.98	330.6	329.53	330.195	1607287.0
2021-02-05 10:30:00	QQQ	ETF	330.18	330.78	329.77	330.64	1058413.0
2021-02-05 11:00:00	QQQ	ETF	330.64	330.875	329.99	330.17	950255.0
2021-02-05 11:30:00	QQQ	ETF	330.25	330.939	330.21	330.635	787939.0
2021-02-05 12:00:00	QQQ	ETF	330.638	331.59	330.51	331.48	990181.0
2021-02-05 12:30:00	QQQ	ETF	331.5	332.25	331.37	332.24	991253.0

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

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