PREVIEW / etf_5min / 2007-07-20

all etf 5-min files

  file:    by_date/etf_5min/2007/2007-07-20.parquet
  size:    363 KB
  rows:    17,980

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-07-20 04:15:00	SPY	ETF	155.06	155.06	155.06	155.06	1500.0
2007-07-20 04:35:00	SPY	ETF	154.92	154.92	154.9	154.9	2000.0
2007-07-20 04:40:00	SPY	ETF	154.92	154.92	154.92	154.92	1000.0
2007-07-20 04:50:00	SPY	ETF	154.87	154.87	154.87	154.87	1000.0
2007-07-20 05:00:00	SPY	ETF	154.79	154.79	154.79	154.79	900.0
2007-07-20 05:15:00	SPY	ETF	154.79	154.83	154.79	154.83	3500.0
2007-07-20 05:25:00	SPY	ETF	154.89	154.9	154.89	154.9	2000.0
2007-07-20 05:55:00	SPY	ETF	154.94	154.94	154.94	154.94	1000.0
2007-07-20 06:00:00	SPY	ETF	154.92	154.92	154.92	154.92	900.0
2007-07-20 06:10:00	SPY	ETF	155.06	155.06	155.06	155.06	5000.0
2007-07-20 06:30:00	SPY	ETF	155.11	155.11	155.11	155.11	500.0
2007-07-20 06:35:00	SPY	ETF	155.13	155.13	155.13	155.13	1000.0
2007-07-20 06:40:00	SPY	ETF	155.14	155.14	155.13	155.13	10000.0
2007-07-20 07:00:00	SPY	ETF	155.01	155.02	154.97	154.97	44800.0
2007-07-20 07:05:00	SPY	ETF	154.97	154.98	154.93	154.93	115400.0
2007-07-20 07:10:00	SPY	ETF	154.93	154.94	154.81	154.81	8700.0
2007-07-20 07:15:00	SPY	ETF	154.81	154.84	154.81	154.84	9400.0
2007-07-20 07:20:00	SPY	ETF	154.85	154.92	154.85	154.92	3400.0
2007-07-20 07:25:00	SPY	ETF	154.92	154.95	154.92	154.95	700.0
2007-07-20 07:30:00	SPY	ETF	154.88	154.88	154.77	154.77	90500.0
2007-07-20 07:35:00	SPY	ETF	154.79	154.84	154.78	154.8	18000.0
2007-07-20 07:40:00	SPY	ETF	154.8	154.8	154.72	154.74	43500.0
2007-07-20 07:45:00	SPY	ETF	154.73	154.73	154.66	154.69	122800.0
2007-07-20 07:50:00	SPY	ETF	154.7	154.7	154.61	154.64	55000.0
2007-07-20 07:55:00	SPY	ETF	154.64	154.7	154.59	154.67	106300.0
2007-07-20 08:00:00	SPY	ETF	154.6	154.73	154.59	154.73	408600.0
2007-07-20 08:05:00	SPY	ETF	154.71	154.76	154.68	154.68	135800.0
2007-07-20 08:10:00	SPY	ETF	154.66	154.66	154.57	154.6	129500.0
2007-07-20 08:15:00	SPY	ETF	154.6	154.71	154.58	154.69	80500.0
2007-07-20 08:20:00	SPY	ETF	154.72	154.72	154.63	154.63	145900.0
2007-07-20 08:25:00	SPY	ETF	154.65	154.7	154.6	154.69	160300.0
2007-07-20 08:30:00	SPY	ETF	154.69	154.8	154.66	154.75	197800.0
2007-07-20 08:35:00	SPY	ETF	154.78	154.87	154.74	154.85	313700.0
2007-07-20 08:40:00	SPY	ETF	154.85	154.87	154.8	154.86	128400.0
2007-07-20 08:45:00	SPY	ETF	154.87	154.91	154.84	154.89	111000.0
2007-07-20 08:50:00	SPY	ETF	154.89	154.89	154.86	154.87	54800.0
2007-07-20 08:55:00	SPY	ETF	154.88	154.92	154.85	154.91	115300.0
2007-07-20 09:00:00	SPY	ETF	154.9	154.93	154.88	154.93	49100.0
2007-07-20 09:05:00	SPY	ETF	154.92	154.92	154.78	154.78	108100.0
2007-07-20 09:10:00	SPY	ETF	154.8	154.8	154.75	154.75	161400.0
2007-07-20 09:15:00	SPY	ETF	154.74	154.78	154.69	154.72	168600.0
2007-07-20 09:20:00	SPY	ETF	154.72	154.76	154.66	154.75	295300.0
2007-07-20 09:25:00	SPY	ETF	154.74	155.07	154.68	154.87	1137200.0
2007-07-20 09:30:00	SPY	ETF	154.89	154.97	154.82	154.95	4276244.0
2007-07-20 09:35:00	SPY	ETF	154.95	154.99	154.8	154.85	2653465.0
2007-07-20 09:40:00	SPY	ETF	154.85	154.95	154.73	154.73	2424273.0
2007-07-20 09:45:00	SPY	ETF	154.72	154.98	154.65	154.72	2169093.0
2007-07-20 09:50:00	SPY	ETF	154.72	154.81	154.52	154.53	3674345.0
2007-07-20 09:55:00	SPY	ETF	154.53	154.54	154.09	154.32	4858237.0
2007-07-20 10:00:00	SPY	ETF	154.31	154.32	154.04	154.18	5085700.0

> showing 50 of 17,980 rows — these rows as CSV

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