PREVIEW / etf_5min / 2009-01-30
file: by_date/etf_5min/2009/2009-01-30.parquet size: 641 KB rows: 27,616
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-01-30 04:15:00 | SPY | ETF | 85.2 | 85.2 | 85.2 | 85.2 | 100.0 |
| 2009-01-30 04:55:00 | SPY | ETF | 85.01 | 85.01 | 85.01 | 85.01 | 100.0 |
| 2009-01-30 05:10:00 | SPY | ETF | 84.7 | 84.7 | 84.7 | 84.7 | 200.0 |
| 2009-01-30 05:20:00 | SPY | ETF | 84.83 | 84.83 | 84.83 | 84.83 | 100.0 |
| 2009-01-30 06:00:00 | SPY | ETF | 85.11 | 85.11 | 85.11 | 85.11 | 100.0 |
| 2009-01-30 06:15:00 | SPY | ETF | 84.91 | 84.91 | 84.91 | 84.91 | 500.0 |
| 2009-01-30 06:20:00 | SPY | ETF | 84.96 | 84.96 | 84.96 | 84.96 | 200.0 |
| 2009-01-30 06:25:00 | SPY | ETF | 84.86 | 84.86 | 84.86 | 84.86 | 100.0 |
| 2009-01-30 06:30:00 | SPY | ETF | 84.86 | 84.86 | 84.86 | 84.86 | 500.0 |
| 2009-01-30 06:35:00 | SPY | ETF | 84.72 | 84.72 | 84.66 | 84.71 | 10700.0 |
| 2009-01-30 06:45:00 | SPY | ETF | 84.83 | 84.83 | 84.82 | 84.82 | 10000.0 |
| 2009-01-30 06:50:00 | SPY | ETF | 84.58 | 84.58 | 84.54 | 84.54 | 50200.0 |
| 2009-01-30 06:55:00 | SPY | ETF | 84.57 | 84.6 | 84.57 | 84.6 | 21000.0 |
| 2009-01-30 07:00:00 | SPY | ETF | 84.49 | 84.54 | 84.29 | 84.36 | 32200.0 |
| 2009-01-30 07:05:00 | SPY | ETF | 84.32 | 84.45 | 84.31 | 84.45 | 72500.0 |
| 2009-01-30 07:10:00 | SPY | ETF | 84.39 | 84.39 | 84.29 | 84.32 | 24289.0 |
| 2009-01-30 07:15:00 | SPY | ETF | 84.27 | 84.41 | 84.26 | 84.4 | 54200.0 |
| 2009-01-30 07:20:00 | SPY | ETF | 84.41 | 84.41 | 84.34 | 84.34 | 3000.0 |
| 2009-01-30 07:25:00 | SPY | ETF | 84.36 | 84.43 | 84.36 | 84.43 | 17400.0 |
| 2009-01-30 07:30:00 | SPY | ETF | 84.41 | 84.44 | 84.41 | 84.41 | 17100.0 |
| 2009-01-30 07:35:00 | SPY | ETF | 84.4 | 84.4 | 83.8 | 83.82 | 186774.0 |
| 2009-01-30 07:40:00 | SPY | ETF | 83.87 | 83.96 | 83.85 | 83.94 | 298873.0 |
| 2009-01-30 07:45:00 | SPY | ETF | 83.93 | 83.93 | 83.88 | 83.93 | 204538.0 |
| 2009-01-30 07:50:00 | SPY | ETF | 83.94 | 84.04 | 83.92 | 83.93 | 111401.0 |
| 2009-01-30 07:55:00 | SPY | ETF | 83.92 | 83.92 | 83.75 | 83.81 | 80759.0 |
| 2009-01-30 08:00:00 | SPY | ETF | 83.82 | 84.37 | 83.82 | 84.1 | 318210.0 |
| 2009-01-30 08:05:00 | SPY | ETF | 84.09 | 84.12 | 84.03 | 84.12 | 83530.0 |
| 2009-01-30 08:10:00 | SPY | ETF | 84.11 | 84.13 | 84.06 | 84.13 | 135034.0 |
| 2009-01-30 08:15:00 | SPY | ETF | 84.11 | 84.16 | 84.05 | 84.1 | 198019.0 |
| 2009-01-30 08:20:00 | SPY | ETF | 84.11 | 84.13 | 83.99 | 84.08 | 203445.0 |
| 2009-01-30 08:25:00 | SPY | ETF | 84.1 | 84.32 | 84.03 | 84.13 | 467858.0 |
| 2009-01-30 08:30:00 | SPY | ETF | 84.14 | 85.1 | 84.14 | 84.66 | 5329716.0 |
| 2009-01-30 08:35:00 | SPY | ETF | 84.67 | 84.68 | 84.27 | 84.55 | 2057739.0 |
| 2009-01-30 08:40:00 | SPY | ETF | 84.54 | 84.55 | 84.32 | 84.5 | 899781.0 |
| 2009-01-30 08:45:00 | SPY | ETF | 84.5 | 84.8 | 84.48 | 84.79 | 732460.0 |
| 2009-01-30 08:50:00 | SPY | ETF | 84.8 | 84.92 | 84.76 | 84.77 | 413321.0 |
| 2009-01-30 08:55:00 | SPY | ETF | 84.77 | 84.92 | 84.69 | 84.91 | 655646.0 |
| 2009-01-30 09:00:00 | SPY | ETF | 84.9 | 84.9 | 84.61 | 84.65 | 1023303.0 |
| 2009-01-30 09:05:00 | SPY | ETF | 84.66 | 84.85 | 84.64 | 84.74 | 378260.0 |
| 2009-01-30 09:10:00 | SPY | ETF | 84.73 | 84.85 | 84.7 | 84.72 | 238156.0 |
| 2009-01-30 09:15:00 | SPY | ETF | 84.72 | 84.74 | 84.5 | 84.55 | 693770.0 |
| 2009-01-30 09:20:00 | SPY | ETF | 84.55 | 84.88 | 84.54 | 84.87 | 314517.0 |
| 2009-01-30 09:25:00 | SPY | ETF | 84.88 | 84.99 | 84.83 | 84.98 | 631984.0 |
| 2009-01-30 09:30:00 | SPY | ETF | 84.98 | 85.23 | 84.78 | 85.0 | 5410367.0 |
| 2009-01-30 09:35:00 | SPY | ETF | 85.0 | 85.25 | 84.93 | 84.93 | 5799777.0 |
| 2009-01-30 09:40:00 | SPY | ETF | 84.935 | 84.98 | 84.72 | 84.82 | 5055993.0 |
| 2009-01-30 09:45:00 | SPY | ETF | 84.82 | 85.4 | 84.74 | 84.79 | 11484670.0 |
| 2009-01-30 09:50:00 | SPY | ETF | 84.79 | 84.96 | 84.67 | 84.68 | 4853833.0 |
| 2009-01-30 09:55:00 | SPY | ETF | 84.68 | 84.86 | 84.23 | 84.23 | 5843098.0 |
| 2009-01-30 10:00:00 | SPY | ETF | 84.23 | 84.6 | 84.06 | 84.14 | 5034397.0 |
> showing 50 of 27,616 rows — these rows as CSV