PREVIEW / etf_30min / 2022-10-13

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-10-13.parquet
  size:    687 KB
  rows:    28,173

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-13 04:00:00	SPY	ETF	357.35	357.43	356.9	357.35	15747.0
2022-10-13 04:30:00	SPY	ETF	357.39	358.23	357.39	358.2	14258.0
2022-10-13 05:00:00	SPY	ETF	358.2	358.9	358.19	358.64	31510.0
2022-10-13 05:30:00	SPY	ETF	358.7	358.86	358.2	358.26	18036.0
2022-10-13 06:00:00	SPY	ETF	358.26	358.5	358.06	358.39	111255.0
2022-10-13 06:30:00	SPY	ETF	358.39	358.86	358.3	358.6	38142.0
2022-10-13 07:00:00	SPY	ETF	358.6	359.11	358.5	358.94	235590.0
2022-10-13 07:30:00	SPY	ETF	359.0	361.12	358.87	360.12	805414.0
2022-10-13 08:00:00	SPY	ETF	358.59	361.99	356.2	360.2	1431997.0
2022-10-13 08:30:00	SPY	ETF	360.18	360.37	348.53	349.9	6998483.0
2022-10-13 09:00:00	SPY	ETF	349.9	350.36	348.27	349.23	2033164.0
2022-10-13 09:30:00	SPY	ETF	349.23	352.5	348.11	351.96	12688794.0
2022-10-13 10:00:00	SPY	ETF	351.96	354.1409	351.4	352.0	8463388.0
2022-10-13 10:30:00	SPY	ETF	351.97	354.72	351.77	353.6	6448947.0
2022-10-13 11:00:00	SPY	ETF	353.59	362.72	353.3534	360.28	14413850.0
2022-10-13 11:30:00	SPY	ETF	360.29	365.34	359.82	362.86	12597615.0
2022-10-13 12:00:00	SPY	ETF	362.87	364.05	360.9499	361.32	6635674.0
2022-10-13 12:30:00	SPY	ETF	361.33	363.71	361.11	362.94	4539543.0
2022-10-13 13:00:00	SPY	ETF	362.96	365.74	362.91	365.29	4407875.0
2022-10-13 13:30:00	SPY	ETF	365.35	366.49	364.85	365.556	5910668.0
2022-10-13 14:00:00	SPY	ETF	365.52	365.7	363.96	364.1	4053291.0
2022-10-13 14:30:00	SPY	ETF	364.08	367.13	364.08	366.8	5199799.0
2022-10-13 15:00:00	SPY	ETF	366.7801	367.51	365.98	366.08	6838034.0
2022-10-13 15:30:00	SPY	ETF	366.07	367.17	365.04	365.96	12885997.0
2022-10-13 16:00:00	SPY	ETF	365.96	366.57	365.58	365.99	4939919.0
2022-10-13 16:30:00	SPY	ETF	365.96	366.09	365.75	365.79	247938.0
2022-10-13 17:00:00	SPY	ETF	365.84	365.84	365.6	365.72	50324.0
2022-10-13 17:30:00	SPY	ETF	365.66	365.95	365.65	365.82	38941.0
2022-10-13 18:00:00	SPY	ETF	365.83	366.29	365.6	365.72	84400.0
2022-10-13 18:30:00	SPY	ETF	365.71	366.27	365.71	366.1	30426.0
2022-10-13 19:00:00	SPY	ETF	365.97	366.11	365.8	366.05	19679.0
2022-10-13 19:30:00	SPY	ETF	366.06	366.12	365.71	365.76	56483.0
2022-10-13 20:00:00	SPY	ETF	365.72	365.72	365.72	365.72	100.0
2022-10-13 04:00:00	QQQ	ETF	262.79	262.93	262.53	262.65	21767.0
2022-10-13 04:30:00	QQQ	ETF	263.0	263.39	263.0	263.35	12240.0
2022-10-13 05:00:00	QQQ	ETF	263.34	263.86	263.34	263.63	26521.0
2022-10-13 05:30:00	QQQ	ETF	263.77	263.89	263.3	263.3	11121.0
2022-10-13 06:00:00	QQQ	ETF	263.44	263.58	263.26	263.52	8824.0
2022-10-13 06:30:00	QQQ	ETF	263.49	263.82	263.43	263.59	41683.0
2022-10-13 07:00:00	QQQ	ETF	263.56	264.0	263.431	263.82	56621.0
2022-10-13 07:30:00	QQQ	ETF	263.85	265.31	263.74	264.7	298912.0
2022-10-13 08:00:00	QQQ	ETF	263.5901	266.62	262.52	265.28	903439.0
2022-10-13 08:30:00	QQQ	ETF	264.76	264.76	254.63	255.69	6590467.0
2022-10-13 09:00:00	QQQ	ETF	255.6	256.2	254.58	255.18	1393770.0
2022-10-13 09:30:00	QQQ	ETF	255.18	257.84	254.26	257.48	9969671.0
2022-10-13 10:00:00	QQQ	ETF	257.49	259.42	257.01	257.37	8046141.0
2022-10-13 10:30:00	QQQ	ETF	257.37	259.73	257.2	258.505	5164674.0
2022-10-13 11:00:00	QQQ	ETF	258.5	267.14	258.15	264.8989	11386019.0
2022-10-13 11:30:00	QQQ	ETF	264.88	269.56	264.27	266.83	8553855.0
2022-10-13 12:00:00	QQQ	ETF	266.84	267.86	264.65	264.98	4804179.0

> showing 50 of 28,173 rows — these rows as CSV

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