PREVIEW / etf_5min / 2009-02-06
file: by_date/etf_5min/2009/2009-02-06.parquet size: 665 KB rows: 28,171
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-02-06 04:15:00 | SPY | ETF | 84.25 | 84.25 | 84.25 | 84.25 | 1900.0 |
| 2009-02-06 04:50:00 | SPY | ETF | 84.52 | 84.52 | 84.5 | 84.5 | 800.0 |
| 2009-02-06 05:35:00 | SPY | ETF | 84.5 | 84.5 | 84.5 | 84.5 | 2500.0 |
| 2009-02-06 06:05:00 | SPY | ETF | 84.62 | 84.62 | 84.62 | 84.62 | 700.0 |
| 2009-02-06 06:30:00 | SPY | ETF | 84.49 | 84.49 | 84.49 | 84.49 | 10000.0 |
| 2009-02-06 06:35:00 | SPY | ETF | 84.5 | 84.5 | 84.5 | 84.5 | 600.0 |
| 2009-02-06 06:40:00 | SPY | ETF | 84.57 | 84.62 | 84.57 | 84.62 | 1300.0 |
| 2009-02-06 06:45:00 | SPY | ETF | 84.57 | 84.75 | 84.57 | 84.73 | 2500.0 |
| 2009-02-06 06:50:00 | SPY | ETF | 84.77 | 84.78 | 84.75 | 84.75 | 7700.0 |
| 2009-02-06 06:55:00 | SPY | ETF | 84.72 | 84.73 | 84.72 | 84.73 | 15500.0 |
| 2009-02-06 07:00:00 | SPY | ETF | 84.7 | 84.75 | 84.69 | 84.75 | 33200.0 |
| 2009-02-06 07:05:00 | SPY | ETF | 84.62 | 84.75 | 84.62 | 84.74 | 16100.0 |
| 2009-02-06 07:10:00 | SPY | ETF | 84.74 | 84.8 | 84.73 | 84.78 | 22158.0 |
| 2009-02-06 07:15:00 | SPY | ETF | 84.75 | 84.8 | 84.68 | 84.68 | 18057.0 |
| 2009-02-06 07:20:00 | SPY | ETF | 84.68 | 84.68 | 84.6 | 84.64 | 49224.0 |
| 2009-02-06 07:25:00 | SPY | ETF | 84.68 | 84.68 | 84.6 | 84.62 | 74700.0 |
| 2009-02-06 07:30:00 | SPY | ETF | 84.63 | 84.68 | 84.61 | 84.67 | 89375.0 |
| 2009-02-06 07:35:00 | SPY | ETF | 84.65 | 84.68 | 84.65 | 84.65 | 65144.0 |
| 2009-02-06 07:40:00 | SPY | ETF | 84.62 | 84.66 | 84.6 | 84.66 | 53388.0 |
| 2009-02-06 07:45:00 | SPY | ETF | 84.65 | 84.65 | 84.43 | 84.43 | 18033.0 |
| 2009-02-06 07:50:00 | SPY | ETF | 84.43 | 84.51 | 84.42 | 84.45 | 50929.0 |
| 2009-02-06 07:55:00 | SPY | ETF | 84.45 | 84.64 | 84.43 | 84.62 | 103057.0 |
| 2009-02-06 08:00:00 | SPY | ETF | 84.62 | 84.7 | 84.5 | 84.52 | 315359.0 |
| 2009-02-06 08:05:00 | SPY | ETF | 84.56 | 84.56 | 84.51 | 84.52 | 84502.0 |
| 2009-02-06 08:10:00 | SPY | ETF | 84.52 | 84.52 | 84.42 | 84.46 | 102323.0 |
| 2009-02-06 08:15:00 | SPY | ETF | 84.49 | 84.54 | 84.47 | 84.52 | 184635.0 |
| 2009-02-06 08:20:00 | SPY | ETF | 84.5 | 84.62 | 84.5 | 84.62 | 507850.0 |
| 2009-02-06 08:25:00 | SPY | ETF | 84.61 | 84.77 | 84.55 | 84.58 | 497725.0 |
| 2009-02-06 08:30:00 | SPY | ETF | 84.63 | 84.84 | 84.1 | 84.8 | 4772511.0 |
| 2009-02-06 08:35:00 | SPY | ETF | 84.82 | 85.07 | 84.81 | 84.99 | 2398311.0 |
| 2009-02-06 08:40:00 | SPY | ETF | 84.98 | 85.15 | 84.66 | 84.86 | 1445420.0 |
| 2009-02-06 08:45:00 | SPY | ETF | 84.84 | 84.86 | 84.69 | 84.86 | 371632.0 |
| 2009-02-06 08:50:00 | SPY | ETF | 84.86 | 85.26 | 84.86 | 85.11 | 973397.0 |
| 2009-02-06 08:55:00 | SPY | ETF | 85.08 | 85.17 | 85.02 | 85.08 | 1227722.0 |
| 2009-02-06 09:00:00 | SPY | ETF | 85.08 | 85.2 | 84.98 | 85.06 | 679848.0 |
| 2009-02-06 09:05:00 | SPY | ETF | 85.07 | 85.16 | 84.9 | 84.97 | 386537.0 |
| 2009-02-06 09:10:00 | SPY | ETF | 84.97 | 84.97 | 84.84 | 84.97 | 435974.0 |
| 2009-02-06 09:15:00 | SPY | ETF | 84.96 | 85.01 | 84.85 | 84.92 | 273484.0 |
| 2009-02-06 09:20:00 | SPY | ETF | 84.92 | 84.93 | 84.76 | 84.86 | 368102.0 |
| 2009-02-06 09:25:00 | SPY | ETF | 84.86 | 84.9 | 84.78 | 84.84 | 257040.0 |
| 2009-02-06 09:30:00 | SPY | ETF | 84.86 | 85.18 | 84.68 | 85.16 | 6848747.0 |
| 2009-02-06 09:35:00 | SPY | ETF | 85.16 | 86.01 | 85.12 | 85.83 | 15681350.0 |
| 2009-02-06 09:40:00 | SPY | ETF | 85.83 | 86.04 | 85.7 | 85.87 | 10278986.0 |
| 2009-02-06 09:45:00 | SPY | ETF | 85.86 | 86.19 | 85.86 | 86.0 | 7897746.0 |
| 2009-02-06 09:50:00 | SPY | ETF | 86.01 | 86.15 | 85.9 | 86.14 | 5198648.0 |
| 2009-02-06 09:55:00 | SPY | ETF | 86.13 | 86.32 | 86.01 | 86.17 | 5632106.0 |
| 2009-02-06 10:00:00 | SPY | ETF | 86.18 | 87.0069 | 86.04 | 86.06 | 5446180.0 |
| 2009-02-06 10:05:00 | SPY | ETF | 86.06 | 86.14 | 85.89 | 85.97 | 5666030.0 |
| 2009-02-06 10:10:00 | SPY | ETF | 85.96 | 86.22 | 85.96 | 86.1798 | 4079469.0 |
| 2009-02-06 10:15:00 | SPY | ETF | 86.18 | 86.2805 | 85.94 | 85.98 | 3601540.0 |
> showing 50 of 28,171 rows — these rows as CSV