PREVIEW / etf_30min / 2022-10-12

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-10-12.parquet
  size:    661 KB
  rows:    26,487

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
2022-10-12 04:00:00	SPY	ETF	359.22	360.07	358.82	360.0	32238.0
2022-10-12 04:30:00	SPY	ETF	360.01	360.09	359.3	359.7	23674.0
2022-10-12 05:00:00	SPY	ETF	359.6	361.19	359.51	361.15	18971.0
2022-10-12 05:30:00	SPY	ETF	361.08	361.08	360.29	360.5	12546.0
2022-10-12 06:00:00	SPY	ETF	360.54	360.97	359.65	359.82	14692.0
2022-10-12 06:30:00	SPY	ETF	359.83	359.94	359.11	359.85	43094.0
2022-10-12 07:00:00	SPY	ETF	360.0	360.47	359.16	360.38	153929.0
2022-10-12 07:30:00	SPY	ETF	360.47	360.75	359.9	359.98	127866.0
2022-10-12 08:00:00	SPY	ETF	360.05	361.05	359.1	360.5	628364.0
2022-10-12 08:30:00	SPY	ETF	360.53	360.53	357.74	358.6	1415942.0
2022-10-12 09:00:00	SPY	ETF	358.58	358.61	357.47	358.14	877126.0
2022-10-12 09:30:00	SPY	ETF	358.17	359.8179	356.3	358.8279	8366692.0
2022-10-12 10:00:00	SPY	ETF	358.82	359.45	357.0	358.4	4268567.0
2022-10-12 10:30:00	SPY	ETF	358.41	359.19	357.09	357.83	3420504.0
2022-10-12 11:00:00	SPY	ETF	357.88	359.2	357.76	358.74	3014244.0
2022-10-12 11:30:00	SPY	ETF	358.8	359.45	358.13	359.19	3159143.0
2022-10-12 12:00:00	SPY	ETF	359.22	359.8	358.032	358.19	2706414.0
2022-10-12 12:30:00	SPY	ETF	358.16	358.73	357.62	358.58	2426499.0
2022-10-12 13:00:00	SPY	ETF	358.58	358.82	357.94	358.28	2123457.0
2022-10-12 13:30:00	SPY	ETF	358.29	358.35	357.32	357.6599	2172274.0
2022-10-12 14:00:00	SPY	ETF	357.61	359.27	357.11	359.0551	5559790.0
2022-10-12 14:30:00	SPY	ETF	359.0457	359.4	357.45	357.69	3063522.0
2022-10-12 15:00:00	SPY	ETF	357.69	358.17	357.1462	357.61	3552493.0
2022-10-12 15:30:00	SPY	ETF	357.62	358.3	356.5	356.55	8563384.0
2022-10-12 16:00:00	SPY	ETF	356.54	359.81	356.52	357.02	3222545.0
2022-10-12 16:30:00	SPY	ETF	357.02	357.18	356.93	357.07	410262.0
2022-10-12 17:00:00	SPY	ETF	357.1	357.14	356.56	357.03	96714.0
2022-10-12 17:30:00	SPY	ETF	357.03	357.29	357.03	357.29	39269.0
2022-10-12 18:00:00	SPY	ETF	357.3	357.55	357.18	357.29	64126.0
2022-10-12 18:30:00	SPY	ETF	357.3	357.32	357.19	357.27	22921.0
2022-10-12 19:00:00	SPY	ETF	357.22	357.42	357.11	357.34	37349.0
2022-10-12 19:30:00	SPY	ETF	357.38	357.71	357.38	357.59	30343.0
2022-10-12 20:00:00	SPY	ETF	357.6	357.6	357.58	357.58	392.0
2022-10-12 04:00:00	QQQ	ETF	263.86	265.09	263.86	265.09	82363.0
2022-10-12 04:30:00	QQQ	ETF	264.93	264.94	264.53	264.78	23327.0
2022-10-12 05:00:00	QQQ	ETF	264.75	266.02	264.6	266.02	13327.0
2022-10-12 05:30:00	QQQ	ETF	265.94	266.02	265.25	265.5	17696.0
2022-10-12 06:00:00	QQQ	ETF	265.48	265.76	264.91	265.04	23761.0
2022-10-12 06:30:00	QQQ	ETF	265.05	265.12	264.58	265.03	72723.0
2022-10-12 07:00:00	QQQ	ETF	265.03	265.51	264.87	265.5	149386.0
2022-10-12 07:30:00	QQQ	ETF	265.5	265.63	265.01	265.2	144192.0
2022-10-12 08:00:00	QQQ	ETF	265.2	265.8995	262.75	265.64	329036.0
2022-10-12 08:30:00	QQQ	ETF	265.42	265.42	263.08	263.95	1491678.0
2022-10-12 09:00:00	QQQ	ETF	263.94	263.97	262.89	263.42	824951.0
2022-10-12 09:30:00	QQQ	ETF	263.4	265.36	261.95	264.01	6282665.0
2022-10-12 10:00:00	QQQ	ETF	264.09	264.44	262.09	263.4155	3559522.0
2022-10-12 10:30:00	QQQ	ETF	263.42	264.0	262.0204	262.7	2377890.0
2022-10-12 11:00:00	QQQ	ETF	262.7384	264.32	262.61	263.9905	2098355.0
2022-10-12 11:30:00	QQQ	ETF	264.01	264.77	263.4311	264.55	2106869.0
2022-10-12 12:00:00	QQQ	ETF	264.57	264.849	263.2	263.33	1798830.0

> showing 50 of 26,487 rows — these rows as CSV

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