PREVIEW / etf_5min / 2009-10-13
file: by_date/etf_5min/2009/2009-10-13.parquet size: 693 KB rows: 29,843
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 |
|---|---|---|---|---|---|---|---|
| 2009-10-13 04:05:00 | SPY | ETF | 107.44 | 107.44 | 107.43 | 107.43 | 5000.0 |
| 2009-10-13 04:15:00 | SPY | ETF | 107.42 | 107.42 | 107.42 | 107.42 | 1300.0 |
| 2009-10-13 04:55:00 | SPY | ETF | 107.54 | 107.54 | 107.54 | 107.54 | 100.0 |
| 2009-10-13 05:00:00 | SPY | ETF | 107.44 | 107.44 | 107.44 | 107.44 | 2222.0 |
| 2009-10-13 05:05:00 | SPY | ETF | 107.48 | 107.48 | 107.48 | 107.48 | 2000.0 |
| 2009-10-13 05:10:00 | SPY | ETF | 107.41 | 107.41 | 107.41 | 107.41 | 500.0 |
| 2009-10-13 05:15:00 | SPY | ETF | 107.36 | 107.36 | 107.3 | 107.3 | 2322.0 |
| 2009-10-13 05:25:00 | SPY | ETF | 107.36 | 107.36 | 107.36 | 107.36 | 2000.0 |
| 2009-10-13 05:30:00 | SPY | ETF | 107.34 | 107.34 | 107.34 | 107.34 | 200.0 |
| 2009-10-13 05:45:00 | SPY | ETF | 107.43 | 107.45 | 107.43 | 107.45 | 6500.0 |
| 2009-10-13 06:05:00 | SPY | ETF | 107.5 | 107.5 | 107.5 | 107.5 | 500.0 |
| 2009-10-13 06:10:00 | SPY | ETF | 107.54 | 107.54 | 107.54 | 107.54 | 500.0 |
| 2009-10-13 06:15:00 | SPY | ETF | 107.56 | 107.56 | 107.56 | 107.56 | 500.0 |
| 2009-10-13 06:40:00 | SPY | ETF | 107.57 | 107.57 | 107.57 | 107.57 | 300.0 |
| 2009-10-13 06:45:00 | SPY | ETF | 107.62 | 107.62 | 107.61 | 107.61 | 50000.0 |
| 2009-10-13 06:50:00 | SPY | ETF | 107.6 | 107.6 | 107.6 | 107.6 | 100.0 |
| 2009-10-13 06:55:00 | SPY | ETF | 107.61 | 107.61 | 107.61 | 107.61 | 100.0 |
| 2009-10-13 07:00:00 | SPY | ETF | 107.62 | 107.65 | 107.61 | 107.64 | 23292.0 |
| 2009-10-13 07:05:00 | SPY | ETF | 107.63 | 107.69 | 107.63 | 107.68 | 29598.0 |
| 2009-10-13 07:10:00 | SPY | ETF | 107.7 | 107.8 | 107.7 | 107.8 | 50300.0 |
| 2009-10-13 07:15:00 | SPY | ETF | 107.78 | 107.84 | 107.78 | 107.78 | 60166.0 |
| 2009-10-13 07:20:00 | SPY | ETF | 107.79 | 107.79 | 107.75 | 107.79 | 14605.0 |
| 2009-10-13 07:25:00 | SPY | ETF | 107.76 | 107.8 | 107.76 | 107.76 | 18200.0 |
| 2009-10-13 07:30:00 | SPY | ETF | 107.77 | 107.79 | 107.75 | 107.78 | 18020.0 |
| 2009-10-13 07:35:00 | SPY | ETF | 107.78 | 107.78 | 107.76 | 107.76 | 2890.0 |
| 2009-10-13 07:40:00 | SPY | ETF | 107.78 | 107.8 | 107.76 | 107.79 | 62100.0 |
| 2009-10-13 07:45:00 | SPY | ETF | 107.8 | 107.89 | 107.79 | 107.83 | 120341.0 |
| 2009-10-13 07:50:00 | SPY | ETF | 107.83 | 107.83 | 107.77 | 107.79 | 40843.0 |
| 2009-10-13 07:55:00 | SPY | ETF | 107.78 | 107.78 | 107.69 | 107.69 | 19900.0 |
| 2009-10-13 08:00:00 | SPY | ETF | 107.69 | 107.8 | 107.65 | 107.65 | 47038.0 |
| 2009-10-13 08:05:00 | SPY | ETF | 107.64 | 107.67 | 107.64 | 107.66 | 368399.0 |
| 2009-10-13 08:10:00 | SPY | ETF | 107.66 | 107.72 | 107.65 | 107.67 | 218924.0 |
| 2009-10-13 08:15:00 | SPY | ETF | 107.68 | 107.69 | 107.55 | 107.56 | 256698.0 |
| 2009-10-13 08:20:00 | SPY | ETF | 107.55 | 107.57 | 107.51 | 107.56 | 117516.0 |
| 2009-10-13 08:25:00 | SPY | ETF | 107.57 | 107.62 | 107.57 | 107.59 | 112524.0 |
| 2009-10-13 08:30:00 | SPY | ETF | 107.6 | 107.63 | 107.59 | 107.63 | 150709.0 |
| 2009-10-13 08:35:00 | SPY | ETF | 107.62 | 107.65 | 107.62 | 107.63 | 71486.0 |
| 2009-10-13 08:40:00 | SPY | ETF | 107.63 | 107.63 | 107.59 | 107.59 | 171630.0 |
| 2009-10-13 08:45:00 | SPY | ETF | 107.59 | 107.59 | 107.54 | 107.56 | 114190.0 |
| 2009-10-13 08:50:00 | SPY | ETF | 107.56 | 107.56 | 107.46 | 107.46 | 153166.0 |
| 2009-10-13 08:55:00 | SPY | ETF | 107.46 | 107.49 | 107.42 | 107.43 | 235975.0 |
| 2009-10-13 09:00:00 | SPY | ETF | 107.44 | 107.45 | 107.33 | 107.37 | 535127.0 |
| 2009-10-13 09:05:00 | SPY | ETF | 107.36 | 107.47 | 107.32 | 107.47 | 255813.0 |
| 2009-10-13 09:10:00 | SPY | ETF | 107.47 | 107.47 | 107.4 | 107.43 | 295535.0 |
| 2009-10-13 09:15:00 | SPY | ETF | 107.44 | 107.5 | 107.43 | 107.44 | 128838.0 |
| 2009-10-13 09:20:00 | SPY | ETF | 107.44 | 107.44 | 107.37 | 107.41 | 165782.0 |
| 2009-10-13 09:25:00 | SPY | ETF | 107.41 | 107.42 | 107.34 | 107.38 | 339851.0 |
| 2009-10-13 09:30:00 | SPY | ETF | 107.39 | 107.5 | 107.36 | 107.49 | 4447463.0 |
| 2009-10-13 09:35:00 | SPY | ETF | 107.485 | 107.56 | 107.44 | 107.49 | 3060008.0 |
| 2009-10-13 09:40:00 | SPY | ETF | 107.49 | 107.54 | 107.18 | 107.22 | 6376393.0 |
> showing 50 of 29,843 rows — these rows as CSV