PREVIEW / etf_30min / 2021-05-05

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-05-05.parquet
  size:    613 KB
  rows:    23,299

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-05-05 04:00:00	SPY	ETF	416.8	417.02	416.03	417.01	20349.0
2021-05-05 04:30:00	SPY	ETF	417.07	417.16	416.82	416.83	7892.0
2021-05-05 05:00:00	SPY	ETF	416.87	417.17	416.87	416.94	2918.0
2021-05-05 05:30:00	SPY	ETF	416.96	417.16	416.88	417.0	63418.0
2021-05-05 06:00:00	SPY	ETF	417.0	417.12	416.87	417.1	12678.0
2021-05-05 06:30:00	SPY	ETF	417.15	417.28	416.84	417.03	52746.0
2021-05-05 07:00:00	SPY	ETF	416.97	416.98	416.62	416.93	121210.0
2021-05-05 07:30:00	SPY	ETF	416.93	417.1	416.86	416.97	55761.0
2021-05-05 08:00:00	SPY	ETF	416.99	417.48	416.0	417.12	168850.0
2021-05-05 08:30:00	SPY	ETF	417.05	417.18	416.81	417.12	156685.0
2021-05-05 09:00:00	SPY	ETF	417.15	417.5	417.0	417.4	226241.0
2021-05-05 09:30:00	SPY	ETF	417.38	417.44	416.255	416.575	5358142.0
2021-05-05 10:00:00	SPY	ETF	416.58	416.67	414.94	415.815	5777268.0
2021-05-05 10:30:00	SPY	ETF	415.81	416.4999	415.69	416.4	3731320.0
2021-05-05 11:00:00	SPY	ETF	416.41	416.91	416.1312	416.64	2265542.0
2021-05-05 11:30:00	SPY	ETF	416.63	417.57	416.6	417.555	2252471.0
2021-05-05 12:00:00	SPY	ETF	417.56	417.63	417.11	417.1831	2107401.0
2021-05-05 12:30:00	SPY	ETF	417.185	417.3001	416.58	416.64	2596961.0
2021-05-05 13:00:00	SPY	ETF	416.65	416.83	416.33	416.8	2114631.0
2021-05-05 13:30:00	SPY	ETF	416.81	417.129	416.71	416.8799	1963501.0
2021-05-05 14:00:00	SPY	ETF	416.8781	417.1	416.44	417.015	2282831.0
2021-05-05 14:30:00	SPY	ETF	417.015	417.23	416.66	416.7099	2203610.0
2021-05-05 15:00:00	SPY	ETF	416.7	416.82	415.15	415.6001	4886674.0
2021-05-05 15:30:00	SPY	ETF	415.6057	416.14	415.29	415.72	8064265.0
2021-05-05 16:00:00	SPY	ETF	415.72	415.9	415.29	415.79	4069259.0
2021-05-05 16:30:00	SPY	ETF	415.79	415.79	415.4	415.44	173135.0
2021-05-05 17:00:00	SPY	ETF	415.44	415.44	415.14	415.3	109183.0
2021-05-05 17:30:00	SPY	ETF	415.35	415.41	415.3	415.41	19137.0
2021-05-05 18:00:00	SPY	ETF	415.44	415.65	415.13	415.28	123454.0
2021-05-05 18:30:00	SPY	ETF	415.75	415.75	415.14	415.25	17899.0
2021-05-05 19:00:00	SPY	ETF	415.3	415.58	415.3	415.39	22539.0
2021-05-05 19:30:00	SPY	ETF	415.3	415.7	415.26	415.68	21699.0
2021-05-05 04:00:00	QQQ	ETF	330.74	331.56	330.74	331.56	47746.0
2021-05-05 04:30:00	QQQ	ETF	331.57	331.68	331.3	331.4	16169.0
2021-05-05 05:00:00	QQQ	ETF	331.39	331.85	331.39	331.54	25626.0
2021-05-05 05:30:00	QQQ	ETF	331.58	331.76	331.57	331.59	20301.0
2021-05-05 06:00:00	QQQ	ETF	331.62	331.81	331.54	331.74	18686.0
2021-05-05 06:30:00	QQQ	ETF	331.77	332.07	331.76	331.92	64881.0
2021-05-05 07:00:00	QQQ	ETF	331.94	332.11	331.54	332.03	150241.0
2021-05-05 07:30:00	QQQ	ETF	332.02	332.26	331.83	331.95	91227.0
2021-05-05 08:00:00	QQQ	ETF	331.8704	332.8	329.9	332.33	281920.0
2021-05-05 08:30:00	QQQ	ETF	332.33	332.33	331.4	332.08	408407.0
2021-05-05 09:00:00	QQQ	ETF	332.12	332.56	331.84	332.29	183168.0
2021-05-05 09:30:00	QQQ	ETF	332.25	333.14	331.32	331.47	6359506.0
2021-05-05 10:00:00	QQQ	ETF	331.49	331.65	329.8499	331.11	4851521.0
2021-05-05 10:30:00	QQQ	ETF	331.11	332.06	331.01	331.87	2619682.0
2021-05-05 11:00:00	QQQ	ETF	331.87	332.18	330.99	331.35	2369480.0
2021-05-05 11:30:00	QQQ	ETF	331.35	332.28	331.2318	332.17	1676985.0
2021-05-05 12:00:00	QQQ	ETF	332.19	332.31	331.56	331.69	1221460.0
2021-05-05 12:30:00	QQQ	ETF	331.68	331.8	330.73	330.84	1721286.0

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

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