PREVIEW / etf_30min / 2007-05-10

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-05-10.parquet
  size:    115 KB
  rows:    4,086

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
2007-05-10 06:00:00	SPY	ETF	150.94	151.01	150.94	151.01	1500.0
2007-05-10 06:30:00	SPY	ETF	150.99	150.99	150.99	150.99	1000.0
2007-05-10 07:00:00	SPY	ETF	150.96	151.0	150.89	151.0	167000.0
2007-05-10 07:30:00	SPY	ETF	151.0	151.0	150.76	150.81	140500.0
2007-05-10 08:00:00	SPY	ETF	150.83	150.91	150.76	150.91	984400.0
2007-05-10 08:30:00	SPY	ETF	150.87	150.97	150.73	150.93	445600.0
2007-05-10 09:00:00	SPY	ETF	150.93	150.93	150.72	150.72	729400.0
2007-05-10 09:30:00	SPY	ETF	150.73	150.86	150.55	150.79	12797226.0
2007-05-10 10:00:00	SPY	ETF	150.78	150.98	150.66	150.85	9354894.0
2007-05-10 10:30:00	SPY	ETF	150.85	151.02	150.8	150.89	7826590.0
2007-05-10 11:00:00	SPY	ETF	150.89	150.89	150.24	150.34	12065660.0
2007-05-10 11:30:00	SPY	ETF	150.34	150.7	149.96	149.97	11051770.0
2007-05-10 12:00:00	SPY	ETF	149.98	150.13	149.69	150.03	14465225.0
2007-05-10 12:30:00	SPY	ETF	150.02	150.13	149.95	149.98	7685948.0
2007-05-10 13:00:00	SPY	ETF	149.98	150.0	149.69	149.83	9839207.0
2007-05-10 13:30:00	SPY	ETF	149.83	149.89	149.44	149.79	13528995.0
2007-05-10 14:00:00	SPY	ETF	149.79	150.1	149.76	150.02	10218350.0
2007-05-10 14:30:00	SPY	ETF	150.02	150.07	149.8	149.83	6326602.0
2007-05-10 15:00:00	SPY	ETF	149.84	149.84	149.51	149.65	11196700.0
2007-05-10 15:30:00	SPY	ETF	149.64	149.8351	149.27	149.33	14191263.0
2007-05-10 16:00:00	SPY	ETF	149.34	150.14	149.27	149.52	2988400.0
2007-05-10 16:30:00	SPY	ETF	149.54	149.8833	149.27	149.56	3091600.0
2007-05-10 17:00:00	SPY	ETF	149.53	149.54	149.47	149.54	1158100.0
2007-05-10 17:30:00	SPY	ETF	149.59	149.6	149.5	149.58	35400.0
2007-05-10 18:00:00	SPY	ETF	149.55	149.55	149.5	149.51	27100.0
2007-05-10 18:30:00	SPY	ETF	149.51	149.51	149.48	149.48	19900.0
2007-05-10 19:00:00	SPY	ETF	149.48	149.53	149.48	149.53	900.0
2007-05-10 19:30:00	SPY	ETF	149.53	149.56	149.5	149.5	3000.0
2007-05-10 07:00:00	QQQ	ETF	46.69	46.71	46.68	46.71	75500.0
2007-05-10 07:30:00	QQQ	ETF	46.71	46.73	46.65	46.66	97558.0
2007-05-10 08:00:00	QQQ	ETF	46.68	46.7	46.64	46.69	258829.0
2007-05-10 08:30:00	QQQ	ETF	46.67	46.72	46.63	46.7	1315163.0
2007-05-10 09:00:00	QQQ	ETF	46.71	46.71	46.65	46.66	612623.0
2007-05-10 09:30:00	QQQ	ETF	46.67	46.74	46.6	46.72	11654859.0
2007-05-10 10:00:00	QQQ	ETF	46.72	46.74	46.63	46.7	8138404.0
2007-05-10 10:30:00	QQQ	ETF	46.7	46.78	46.66	46.73	5603059.0
2007-05-10 11:00:00	QQQ	ETF	46.73	46.74	46.43	46.47	12508667.0
2007-05-10 11:30:00	QQQ	ETF	46.47	46.54	46.28	46.28	12447654.0
2007-05-10 12:00:00	QQQ	ETF	46.28	46.34	46.12	46.2999	21651343.0
2007-05-10 12:30:00	QQQ	ETF	46.2974	46.37	46.27	46.27	6072371.0
2007-05-10 13:00:00	QQQ	ETF	46.27	46.29	46.16	46.21	9044016.0
2007-05-10 13:30:00	QQQ	ETF	46.21	46.32	46.11	46.265	20108130.0
2007-05-10 14:00:00	QQQ	ETF	46.2699	46.42	46.26	46.38	9115626.0
2007-05-10 14:30:00	QQQ	ETF	46.37	46.4	46.28	46.29	7355279.0
2007-05-10 15:00:00	QQQ	ETF	46.29	46.29	46.13	46.21	10711569.0
2007-05-10 15:30:00	QQQ	ETF	46.2074	46.23	46.07	46.11	15035764.0
2007-05-10 16:00:00	QQQ	ETF	46.12	46.24	46.11	46.22	13355768.0
2007-05-10 16:30:00	QQQ	ETF	46.2	46.21	46.17	46.18	281125.0
2007-05-10 17:00:00	QQQ	ETF	46.18	46.22	46.17	46.22	155045.0
2007-05-10 17:30:00	QQQ	ETF	46.23	46.26	46.22	46.22	47100.0

> showing 50 of 4,086 rows — these rows as CSV

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