PREVIEW / etf_1min / 2007-07-05
file: by_date/etf_1min/2007/2007-07-05.parquet size: 629 KB rows: 44,102
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-05 04:58:00 | SPY | ETF | 152.49 | 152.49 | 152.49 | 152.49 | 100.0 |
| 2007-07-05 06:40:00 | SPY | ETF | 152.64 | 152.64 | 152.64 | 152.64 | 3500.0 |
| 2007-07-05 06:45:00 | SPY | ETF | 152.52 | 152.52 | 152.52 | 152.52 | 1000.0 |
| 2007-07-05 07:00:00 | SPY | ETF | 152.46 | 152.46 | 152.46 | 152.46 | 2500.0 |
| 2007-07-05 07:01:00 | SPY | ETF | 152.5 | 152.5 | 152.5 | 152.5 | 500.0 |
| 2007-07-05 07:02:00 | SPY | ETF | 152.42 | 152.42 | 152.42 | 152.42 | 5000.0 |
| 2007-07-05 07:03:00 | SPY | ETF | 152.39 | 152.42 | 152.39 | 152.42 | 6700.0 |
| 2007-07-05 07:04:00 | SPY | ETF | 152.42 | 152.42 | 152.42 | 152.42 | 1300.0 |
| 2007-07-05 07:06:00 | SPY | ETF | 152.44 | 152.44 | 152.44 | 152.44 | 24900.0 |
| 2007-07-05 07:07:00 | SPY | ETF | 152.46 | 152.46 | 152.45 | 152.45 | 24900.0 |
| 2007-07-05 07:08:00 | SPY | ETF | 152.45 | 152.45 | 152.45 | 152.45 | 200.0 |
| 2007-07-05 07:13:00 | SPY | ETF | 152.41 | 152.43 | 152.41 | 152.43 | 2500.0 |
| 2007-07-05 07:14:00 | SPY | ETF | 152.43 | 152.43 | 152.43 | 152.43 | 500.0 |
| 2007-07-05 07:28:00 | SPY | ETF | 152.52 | 152.52 | 152.52 | 152.52 | 3100.0 |
| 2007-07-05 07:31:00 | SPY | ETF | 152.54 | 152.54 | 152.54 | 152.54 | 2500.0 |
| 2007-07-05 07:32:00 | SPY | ETF | 152.56 | 152.56 | 152.56 | 152.56 | 2500.0 |
| 2007-07-05 07:33:00 | SPY | ETF | 152.61 | 152.61 | 152.61 | 152.61 | 99900.0 |
| 2007-07-05 07:34:00 | SPY | ETF | 152.55 | 152.55 | 152.55 | 152.55 | 2500.0 |
| 2007-07-05 07:36:00 | SPY | ETF | 152.6 | 152.6 | 152.6 | 152.6 | 1000.0 |
| 2007-07-05 07:37:00 | SPY | ETF | 152.66 | 152.66 | 152.66 | 152.66 | 2500.0 |
| 2007-07-05 07:39:00 | SPY | ETF | 152.62 | 152.62 | 152.62 | 152.62 | 500.0 |
| 2007-07-05 07:44:00 | SPY | ETF | 152.6 | 152.63 | 152.6 | 152.63 | 10700.0 |
| 2007-07-05 07:46:00 | SPY | ETF | 152.62 | 152.65 | 152.62 | 152.65 | 1200.0 |
| 2007-07-05 07:49:00 | SPY | ETF | 152.59 | 152.59 | 152.59 | 152.59 | 4200.0 |
| 2007-07-05 07:52:00 | SPY | ETF | 152.54 | 152.59 | 152.54 | 152.59 | 10300.0 |
| 2007-07-05 07:53:00 | SPY | ETF | 152.59 | 152.59 | 152.56 | 152.56 | 10000.0 |
| 2007-07-05 07:54:00 | SPY | ETF | 152.58 | 152.59 | 152.57 | 152.59 | 6000.0 |
| 2007-07-05 07:55:00 | SPY | ETF | 152.6 | 152.6 | 152.6 | 152.6 | 4000.0 |
| 2007-07-05 07:56:00 | SPY | ETF | 152.58 | 152.68 | 152.58 | 152.68 | 29000.0 |
| 2007-07-05 07:57:00 | SPY | ETF | 152.62 | 152.62 | 152.62 | 152.62 | 2500.0 |
| 2007-07-05 07:58:00 | SPY | ETF | 152.65 | 152.72 | 152.65 | 152.72 | 3400.0 |
| 2007-07-05 07:59:00 | SPY | ETF | 152.72 | 152.72 | 152.68 | 152.68 | 6000.0 |
| 2007-07-05 08:00:00 | SPY | ETF | 152.68 | 152.7 | 152.68 | 152.7 | 5600.0 |
| 2007-07-05 08:01:00 | SPY | ETF | 152.68 | 152.68 | 152.63 | 152.68 | 107900.0 |
| 2007-07-05 08:02:00 | SPY | ETF | 152.69 | 152.69 | 152.68 | 152.68 | 2500.0 |
| 2007-07-05 08:05:00 | SPY | ETF | 152.68 | 152.69 | 152.68 | 152.69 | 400.0 |
| 2007-07-05 08:06:00 | SPY | ETF | 152.71 | 152.74 | 152.71 | 152.74 | 700.0 |
| 2007-07-05 08:07:00 | SPY | ETF | 152.73 | 152.74 | 152.73 | 152.74 | 3000.0 |
| 2007-07-05 08:08:00 | SPY | ETF | 152.73 | 152.74 | 152.73 | 152.74 | 4800.0 |
| 2007-07-05 08:09:00 | SPY | ETF | 152.75 | 152.75 | 152.22 | 152.71 | 37400.0 |
| 2007-07-05 08:10:00 | SPY | ETF | 152.69 | 152.69 | 152.68 | 152.69 | 30300.0 |
| 2007-07-05 08:11:00 | SPY | ETF | 152.69 | 152.69 | 152.69 | 152.69 | 25000.0 |
| 2007-07-05 08:12:00 | SPY | ETF | 152.69 | 152.69 | 152.68 | 152.68 | 3900.0 |
| 2007-07-05 08:13:00 | SPY | ETF | 152.68 | 152.68 | 152.66 | 152.66 | 5000.0 |
| 2007-07-05 08:14:00 | SPY | ETF | 152.7 | 152.7 | 152.7 | 152.7 | 1500.0 |
| 2007-07-05 08:15:00 | SPY | ETF | 152.71 | 152.76 | 152.7 | 152.72 | 75900.0 |
| 2007-07-05 08:16:00 | SPY | ETF | 152.74 | 152.76 | 152.74 | 152.76 | 14600.0 |
| 2007-07-05 08:17:00 | SPY | ETF | 152.74 | 152.74 | 152.69 | 152.7 | 10600.0 |
| 2007-07-05 08:18:00 | SPY | ETF | 152.67 | 152.68 | 152.67 | 152.68 | 2400.0 |
| 2007-07-05 08:19:00 | SPY | ETF | 152.72 | 152.72 | 152.68 | 152.68 | 14000.0 |
> showing 50 of 44,102 rows — these rows as CSV