PREVIEW / etf_5min / 2007-05-04

all etf 5-min files

  file:    by_date/etf_5min/2007/2007-05-04.parquet
  size:    290 KB
  rows:    14,893

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-04 05:25:00	SPY	ETF	150.49	150.49	150.49	150.49	9700.0
2007-05-04 06:00:00	SPY	ETF	150.76	150.76	150.76	150.76	10000.0
2007-05-04 06:05:00	SPY	ETF	150.76	150.82	150.76	150.82	22300.0
2007-05-04 06:15:00	SPY	ETF	150.74	150.74	150.74	150.74	2500.0
2007-05-04 06:25:00	SPY	ETF	150.78	150.78	150.78	150.78	2000.0
2007-05-04 06:55:00	SPY	ETF	150.8	150.8	150.8	150.8	2000.0
2007-05-04 07:00:00	SPY	ETF	150.78	150.78	150.74	150.75	25200.0
2007-05-04 07:05:00	SPY	ETF	150.78	150.78	150.74	150.74	40900.0
2007-05-04 07:10:00	SPY	ETF	150.74	150.75	150.74	150.74	16700.0
2007-05-04 07:15:00	SPY	ETF	150.75	150.75	150.72	150.73	3400.0
2007-05-04 07:20:00	SPY	ETF	150.74	150.75	150.73	150.73	15500.0
2007-05-04 07:25:00	SPY	ETF	150.73	150.73	150.7	150.7	1800.0
2007-05-04 07:30:00	SPY	ETF	150.7	150.72	150.7	150.7	33000.0
2007-05-04 07:35:00	SPY	ETF	150.7	150.7	150.69	150.7	62800.0
2007-05-04 07:40:00	SPY	ETF	150.71	150.72	150.71	150.72	8500.0
2007-05-04 07:45:00	SPY	ETF	150.72	150.78	150.71	150.78	118100.0
2007-05-04 07:50:00	SPY	ETF	150.78	150.81	150.76	150.8	151200.0
2007-05-04 07:55:00	SPY	ETF	150.82	150.85	150.78	150.78	117400.0
2007-05-04 08:00:00	SPY	ETF	150.77	150.88	150.77	150.85	707500.0
2007-05-04 08:05:00	SPY	ETF	150.85	150.93	150.81	150.89	247800.0
2007-05-04 08:10:00	SPY	ETF	150.83	150.9	150.83	150.9	34900.0
2007-05-04 08:15:00	SPY	ETF	150.89	150.9	150.85	150.86	50400.0
2007-05-04 08:20:00	SPY	ETF	150.86	150.91	150.85	150.86	409300.0
2007-05-04 08:25:00	SPY	ETF	150.87	150.95	150.87	150.92	619500.0
2007-05-04 08:30:00	SPY	ETF	150.99	151.25	150.82	150.96	2574600.0
2007-05-04 08:35:00	SPY	ETF	150.96	151.02	150.86	150.86	503400.0
2007-05-04 08:40:00	SPY	ETF	150.88	150.91	150.87	150.87	78100.0
2007-05-04 08:45:00	SPY	ETF	150.88	150.95	150.87	150.93	283200.0
2007-05-04 08:50:00	SPY	ETF	150.92	150.92	150.84	150.84	140300.0
2007-05-04 08:55:00	SPY	ETF	150.83	150.87	150.77	150.79	601400.0
2007-05-04 09:00:00	SPY	ETF	150.79	150.87	150.75	150.83	685600.0
2007-05-04 09:05:00	SPY	ETF	150.84	150.89	150.76	150.88	285600.0
2007-05-04 09:10:00	SPY	ETF	150.87	150.92	150.87	150.9	68500.0
2007-05-04 09:15:00	SPY	ETF	150.9	150.91	150.88	150.88	32300.0
2007-05-04 09:20:00	SPY	ETF	150.88	150.9	150.85	150.86	43400.0
2007-05-04 09:25:00	SPY	ETF	150.86	150.88	150.73	150.75	231500.0
2007-05-04 09:30:00	SPY	ETF	150.75	150.79	150.59	150.65	3418000.0
2007-05-04 09:35:00	SPY	ETF	150.65	150.68	150.43	150.5	2205400.0
2007-05-04 09:40:00	SPY	ETF	150.5	150.66	150.44	150.63	1109600.0
2007-05-04 09:45:00	SPY	ETF	150.63	150.67	150.57	150.61	1540000.0
2007-05-04 09:50:00	SPY	ETF	150.6	150.76	150.6	150.73	1440523.0
2007-05-04 09:55:00	SPY	ETF	150.74	150.82	150.7	150.77	815100.0
2007-05-04 10:00:00	SPY	ETF	150.77	150.9	150.67	150.73	1454200.0
2007-05-04 10:05:00	SPY	ETF	150.73	150.79	150.7	150.73	1140800.0
2007-05-04 10:10:00	SPY	ETF	150.73	150.86	150.72	150.78	963400.0
2007-05-04 10:15:00	SPY	ETF	150.781	150.98	150.78	150.94	1697050.0
2007-05-04 10:20:00	SPY	ETF	150.94	151.03	150.92	150.99	1378500.0
2007-05-04 10:25:00	SPY	ETF	150.99	151.12	150.97	151.01	1950875.0
2007-05-04 10:30:00	SPY	ETF	151.0	151.01	150.9	150.9	1247880.0
2007-05-04 10:35:00	SPY	ETF	150.9	150.9899	150.87	150.88	808800.0

> showing 50 of 14,893 rows — these rows as CSV

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