PREVIEW / etf_5min / 2010-04-07
file: by_date/etf_5min/2010/2010-04-07.parquet size: 787 KB rows: 33,286
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 |
|---|---|---|---|---|---|---|---|
| 2010-04-07 04:15:00 | SPY | ETF | 118.71 | 118.72 | 118.68 | 118.68 | 750.0 |
| 2010-04-07 04:20:00 | SPY | ETF | 118.65 | 118.68 | 118.65 | 118.68 | 300.0 |
| 2010-04-07 04:30:00 | SPY | ETF | 118.66 | 118.66 | 118.66 | 118.66 | 400.0 |
| 2010-04-07 04:45:00 | SPY | ETF | 118.66 | 118.66 | 118.66 | 118.66 | 300.0 |
| 2010-04-07 05:25:00 | SPY | ETF | 118.85 | 118.85 | 118.85 | 118.85 | 200.0 |
| 2010-04-07 05:30:00 | SPY | ETF | 118.86 | 118.86 | 118.86 | 118.86 | 200.0 |
| 2010-04-07 05:35:00 | SPY | ETF | 118.81 | 118.81 | 118.81 | 118.81 | 2500.0 |
| 2010-04-07 05:55:00 | SPY | ETF | 118.84 | 118.84 | 118.84 | 118.84 | 300.0 |
| 2010-04-07 06:00:00 | SPY | ETF | 118.81 | 118.81 | 118.81 | 118.81 | 600.0 |
| 2010-04-07 06:05:00 | SPY | ETF | 118.81 | 118.81 | 118.79 | 118.79 | 2500.0 |
| 2010-04-07 06:15:00 | SPY | ETF | 118.84 | 118.84 | 118.84 | 118.84 | 2000.0 |
| 2010-04-07 06:25:00 | SPY | ETF | 118.78 | 118.78 | 118.78 | 118.78 | 1600.0 |
| 2010-04-07 06:30:00 | SPY | ETF | 118.84 | 118.84 | 118.84 | 118.84 | 500.0 |
| 2010-04-07 06:35:00 | SPY | ETF | 118.85 | 118.85 | 118.81 | 118.81 | 660.0 |
| 2010-04-07 06:50:00 | SPY | ETF | 118.81 | 118.81 | 118.81 | 118.81 | 100.0 |
| 2010-04-07 06:55:00 | SPY | ETF | 118.81 | 118.81 | 118.73 | 118.73 | 9400.0 |
| 2010-04-07 07:00:00 | SPY | ETF | 118.73 | 118.73 | 118.7 | 118.7 | 2297.0 |
| 2010-04-07 07:05:00 | SPY | ETF | 118.69 | 118.72 | 118.69 | 118.71 | 19450.0 |
| 2010-04-07 07:10:00 | SPY | ETF | 118.73 | 118.73 | 118.72 | 118.72 | 1903.0 |
| 2010-04-07 07:15:00 | SPY | ETF | 118.74 | 118.75 | 118.74 | 118.75 | 2525.0 |
| 2010-04-07 07:20:00 | SPY | ETF | 118.75 | 118.75 | 118.73 | 118.73 | 775.0 |
| 2010-04-07 07:25:00 | SPY | ETF | 118.74 | 118.75 | 118.74 | 118.75 | 800.0 |
| 2010-04-07 07:30:00 | SPY | ETF | 118.72 | 118.72 | 118.64 | 118.67 | 54600.0 |
| 2010-04-07 07:35:00 | SPY | ETF | 118.67 | 118.68 | 118.63 | 118.63 | 20200.0 |
| 2010-04-07 07:40:00 | SPY | ETF | 118.64 | 118.7 | 118.64 | 118.7 | 15600.0 |
| 2010-04-07 07:45:00 | SPY | ETF | 118.7 | 118.73 | 118.67 | 118.67 | 21600.0 |
| 2010-04-07 07:50:00 | SPY | ETF | 118.67 | 118.67 | 118.65 | 118.65 | 20000.0 |
| 2010-04-07 07:55:00 | SPY | ETF | 118.66 | 118.66 | 118.63 | 118.63 | 22291.0 |
| 2010-04-07 08:00:00 | SPY | ETF | 118.65 | 118.67 | 118.6 | 118.63 | 56745.0 |
| 2010-04-07 08:05:00 | SPY | ETF | 118.61 | 118.67 | 118.61 | 118.66 | 48400.0 |
| 2010-04-07 08:10:00 | SPY | ETF | 118.67 | 118.7 | 118.63 | 118.63 | 132436.0 |
| 2010-04-07 08:15:00 | SPY | ETF | 118.62 | 118.63 | 118.58 | 118.59 | 110229.0 |
| 2010-04-07 08:20:00 | SPY | ETF | 118.59 | 118.59 | 118.49 | 118.5 | 357722.0 |
| 2010-04-07 08:25:00 | SPY | ETF | 118.51 | 118.54 | 118.46 | 118.54 | 156510.0 |
| 2010-04-07 08:30:00 | SPY | ETF | 118.54 | 118.59 | 118.5 | 118.57 | 56857.0 |
| 2010-04-07 08:35:00 | SPY | ETF | 118.58 | 118.6 | 118.57 | 118.57 | 61926.0 |
| 2010-04-07 08:40:00 | SPY | ETF | 118.57 | 118.59 | 118.57 | 118.57 | 28895.0 |
| 2010-04-07 08:45:00 | SPY | ETF | 118.58 | 118.65 | 118.56 | 118.63 | 157058.0 |
| 2010-04-07 08:50:00 | SPY | ETF | 118.62 | 118.68 | 118.62 | 118.67 | 93846.0 |
| 2010-04-07 08:55:00 | SPY | ETF | 118.67 | 118.69 | 118.65 | 118.67 | 87224.0 |
| 2010-04-07 09:00:00 | SPY | ETF | 118.67 | 118.73 | 118.65 | 118.73 | 103567.0 |
| 2010-04-07 09:05:00 | SPY | ETF | 118.72 | 118.79 | 118.68 | 118.74 | 487128.0 |
| 2010-04-07 09:10:00 | SPY | ETF | 118.74 | 118.76 | 118.72 | 118.73 | 53450.0 |
| 2010-04-07 09:15:00 | SPY | ETF | 118.74 | 118.74 | 118.71 | 118.72 | 85226.0 |
| 2010-04-07 09:20:00 | SPY | ETF | 118.73 | 118.77 | 118.71 | 118.76 | 99957.0 |
| 2010-04-07 09:25:00 | SPY | ETF | 118.76 | 118.8 | 118.76 | 118.8 | 342967.0 |
| 2010-04-07 09:30:00 | SPY | ETF | 118.8 | 118.82 | 118.68 | 118.7 | 4565223.0 |
| 2010-04-07 09:35:00 | SPY | ETF | 118.71 | 118.82 | 118.62 | 118.82 | 3717421.0 |
| 2010-04-07 09:40:00 | SPY | ETF | 118.81 | 118.92 | 118.78 | 118.9 | 2403062.0 |
| 2010-04-07 09:45:00 | SPY | ETF | 118.9 | 118.97 | 118.82 | 118.8201 | 4093438.0 |
> showing 50 of 33,286 rows — these rows as CSV