PREVIEW / etf_30min / 2022-12-08

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-12-08.parquet
  size:    679 KB
  rows:    27,081

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-12-08 04:00:00	SPY	ETF	393.9	394.31	393.67	393.77	21924.0
2022-12-08 04:30:00	SPY	ETF	393.86	394.17	393.51	393.76	25781.0
2022-12-08 05:00:00	SPY	ETF	393.8	394.07	393.64	393.85	9996.0
2022-12-08 05:30:00	SPY	ETF	393.84	393.95	393.46	393.78	19262.0
2022-12-08 06:00:00	SPY	ETF	393.75	393.93	393.47	393.89	11432.0
2022-12-08 06:30:00	SPY	ETF	393.97	394.6	393.95	394.34	23544.0
2022-12-08 07:00:00	SPY	ETF	394.4	394.4	394.05	394.31	109435.0
2022-12-08 07:30:00	SPY	ETF	394.22	394.97	394.12	394.89	233441.0
2022-12-08 08:00:00	SPY	ETF	394.1496	395.23	393.08	395.01	325663.0
2022-12-08 08:30:00	SPY	ETF	395.05	396.57	394.87	395.47	475521.0
2022-12-08 09:00:00	SPY	ETF	395.56	395.76	394.9	395.13	233652.0
2022-12-08 09:30:00	SPY	ETF	395.14	396.2501	393.45	396.18	5191838.0
2022-12-08 10:00:00	SPY	ETF	396.18	397.2	396.0618	396.98	4063607.0
2022-12-08 10:30:00	SPY	ETF	397.0	397.36	396.31	396.6279	2408189.0
2022-12-08 11:00:00	SPY	ETF	396.63	396.895	395.01	395.87	2779438.0
2022-12-08 11:30:00	SPY	ETF	395.875	396.4391	395.53	396.1376	1842258.0
2022-12-08 12:00:00	SPY	ETF	396.14	396.36	395.39	395.56	1787256.0
2022-12-08 12:30:00	SPY	ETF	395.57	396.0	395.065	395.84	1416669.0
2022-12-08 13:00:00	SPY	ETF	395.8536	396.51	395.64	396.4999	1482247.0
2022-12-08 13:30:00	SPY	ETF	396.5	397.27	396.35	396.47	2579947.0
2022-12-08 14:00:00	SPY	ETF	396.47	396.47	394.5	395.1689	4150440.0
2022-12-08 14:30:00	SPY	ETF	395.1623	396.02	394.75	395.53	2476956.0
2022-12-08 15:00:00	SPY	ETF	395.54	396.38	394.87	396.16	3303712.0
2022-12-08 15:30:00	SPY	ETF	396.17	396.58	395.01	396.21	6979084.0
2022-12-08 16:00:00	SPY	ETF	396.22	396.68	396.03	396.6	4340452.0
2022-12-08 16:30:00	SPY	ETF	396.6	396.65	396.1	396.1	265833.0
2022-12-08 17:00:00	SPY	ETF	396.06	396.19	396.01	396.14	24465.0
2022-12-08 17:30:00	SPY	ETF	396.11	396.3	396.11	396.24	60213.0
2022-12-08 18:00:00	SPY	ETF	396.22	396.52	396.16	396.25	48147.0
2022-12-08 18:30:00	SPY	ETF	396.25	396.25	395.96	395.96	29730.0
2022-12-08 19:00:00	SPY	ETF	395.91	396.09	395.73	395.7988	23886.0
2022-12-08 19:30:00	SPY	ETF	395.74	395.9	395.7	395.9	33039.0
2022-12-08 04:00:00	QQQ	ETF	280.8	281.54	280.8	281.07	36375.0
2022-12-08 04:30:00	QQQ	ETF	281.1	281.3	280.86	281.07	29568.0
2022-12-08 05:00:00	QQQ	ETF	281.12	281.34	281.04	281.07	10453.0
2022-12-08 05:30:00	QQQ	ETF	281.25	281.32	280.97	281.19	9455.0
2022-12-08 06:00:00	QQQ	ETF	281.2	281.3	280.89	281.15	8804.0
2022-12-08 06:30:00	QQQ	ETF	281.19	281.51	281.16	281.3	40388.0
2022-12-08 07:00:00	QQQ	ETF	281.26	281.29	281.0	281.2	56974.0
2022-12-08 07:30:00	QQQ	ETF	281.16	281.75	281.06	281.7	170277.0
2022-12-08 08:00:00	QQQ	ETF	281.69	282.02	280.25	281.88	165222.0
2022-12-08 08:30:00	QQQ	ETF	281.9201	282.7	281.75	282.18	462039.0
2022-12-08 09:00:00	QQQ	ETF	282.18	282.31	281.69	281.88	328625.0
2022-12-08 09:30:00	QQQ	ETF	281.91	282.87	279.79	282.81	4913304.0
2022-12-08 10:00:00	QQQ	ETF	282.8	284.3	282.67	283.95	3341105.0
2022-12-08 10:30:00	QQQ	ETF	283.95	284.49	283.39	283.86	2298923.0
2022-12-08 11:00:00	QQQ	ETF	283.84	284.16	282.34	283.36	2729158.0
2022-12-08 11:30:00	QQQ	ETF	283.375	283.99	283.13	283.6	1852366.0
2022-12-08 12:00:00	QQQ	ETF	283.6	283.85	282.7498	282.92	1508683.0
2022-12-08 12:30:00	QQQ	ETF	282.93	283.54	282.7	283.46	1233883.0

> showing 50 of 27,081 rows — these rows as CSV

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