PREVIEW / etf_5min / 2009-06-17
file: by_date/etf_5min/2009/2009-06-17.parquet size: 693 KB rows: 29,752
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-06-17 04:15:00 | SPY | ETF | 91.75 | 91.75 | 91.75 | 91.75 | 100.0 |
| 2009-06-17 04:25:00 | SPY | ETF | 91.78 | 91.81 | 91.78 | 91.81 | 600.0 |
| 2009-06-17 05:00:00 | SPY | ETF | 91.75 | 91.75 | 91.75 | 91.75 | 300.0 |
| 2009-06-17 05:20:00 | SPY | ETF | 91.69 | 91.69 | 91.67 | 91.67 | 1440.0 |
| 2009-06-17 05:30:00 | SPY | ETF | 91.63 | 91.72 | 91.63 | 91.72 | 7000.0 |
| 2009-06-17 06:05:00 | SPY | ETF | 91.56 | 91.56 | 91.56 | 91.56 | 100.0 |
| 2009-06-17 06:10:00 | SPY | ETF | 91.58 | 91.67 | 91.58 | 91.67 | 2100.0 |
| 2009-06-17 06:25:00 | SPY | ETF | 91.74 | 91.74 | 91.7 | 91.7 | 800.0 |
| 2009-06-17 06:30:00 | SPY | ETF | 91.68 | 91.68 | 91.53 | 91.53 | 76150.0 |
| 2009-06-17 06:40:00 | SPY | ETF | 91.6 | 91.6 | 91.6 | 91.6 | 500.0 |
| 2009-06-17 06:45:00 | SPY | ETF | 91.58 | 91.58 | 91.54 | 91.54 | 4400.0 |
| 2009-06-17 06:50:00 | SPY | ETF | 91.49 | 91.53 | 91.49 | 91.49 | 1500.0 |
| 2009-06-17 06:55:00 | SPY | ETF | 91.56 | 91.7 | 91.56 | 91.7 | 34200.0 |
| 2009-06-17 07:00:00 | SPY | ETF | 91.64 | 91.77 | 91.64 | 91.74 | 190158.0 |
| 2009-06-17 07:05:00 | SPY | ETF | 91.76 | 91.87 | 91.76 | 91.83 | 63600.0 |
| 2009-06-17 07:10:00 | SPY | ETF | 91.85 | 91.91 | 91.85 | 91.91 | 8572.0 |
| 2009-06-17 07:15:00 | SPY | ETF | 91.88 | 91.99 | 91.88 | 91.93 | 18500.0 |
| 2009-06-17 07:20:00 | SPY | ETF | 91.95 | 92.01 | 91.93 | 91.97 | 56603.0 |
| 2009-06-17 07:25:00 | SPY | ETF | 91.94 | 92.04 | 91.9 | 92.02 | 211913.0 |
| 2009-06-17 07:30:00 | SPY | ETF | 92.0 | 92.06 | 91.99 | 92.01 | 146568.0 |
| 2009-06-17 07:35:00 | SPY | ETF | 92.01 | 92.01 | 91.99 | 91.99 | 27180.0 |
| 2009-06-17 07:40:00 | SPY | ETF | 91.98 | 92.0 | 91.84 | 91.85 | 295444.0 |
| 2009-06-17 07:45:00 | SPY | ETF | 91.86 | 92.01 | 91.68 | 91.7 | 542293.0 |
| 2009-06-17 07:50:00 | SPY | ETF | 91.71 | 91.72 | 91.56 | 91.56 | 266203.0 |
| 2009-06-17 07:55:00 | SPY | ETF | 91.56 | 91.56 | 91.28 | 91.36 | 873689.0 |
| 2009-06-17 08:00:00 | SPY | ETF | 91.36 | 92.03 | 91.33 | 91.36 | 1580444.0 |
| 2009-06-17 08:05:00 | SPY | ETF | 91.36 | 91.785 | 91.36 | 91.39 | 430339.0 |
| 2009-06-17 08:10:00 | SPY | ETF | 91.4 | 91.48 | 91.38 | 91.48 | 241544.0 |
| 2009-06-17 08:15:00 | SPY | ETF | 91.48 | 91.51 | 91.39 | 91.39 | 360700.0 |
| 2009-06-17 08:20:00 | SPY | ETF | 91.38 | 91.39 | 91.34 | 91.36 | 197550.0 |
| 2009-06-17 08:25:00 | SPY | ETF | 91.35 | 91.5 | 91.35 | 91.47 | 179306.0 |
| 2009-06-17 08:30:00 | SPY | ETF | 91.48 | 91.59 | 91.4 | 91.49 | 585701.0 |
| 2009-06-17 08:35:00 | SPY | ETF | 91.49 | 91.5 | 91.44 | 91.44 | 56969.0 |
| 2009-06-17 08:40:00 | SPY | ETF | 91.45 | 92.0 | 91.45 | 91.58 | 439375.0 |
| 2009-06-17 08:45:00 | SPY | ETF | 91.59 | 91.72 | 91.55 | 91.69 | 392196.0 |
| 2009-06-17 08:50:00 | SPY | ETF | 91.69 | 91.77 | 91.69 | 91.76 | 461142.0 |
| 2009-06-17 08:55:00 | SPY | ETF | 91.76 | 91.79 | 91.7 | 91.71 | 190518.0 |
| 2009-06-17 09:00:00 | SPY | ETF | 91.7 | 91.71 | 91.52 | 91.52 | 321898.0 |
| 2009-06-17 09:05:00 | SPY | ETF | 91.52 | 91.52 | 91.35 | 91.39 | 561296.0 |
| 2009-06-17 09:10:00 | SPY | ETF | 91.39 | 91.56 | 91.38 | 91.52 | 642253.0 |
| 2009-06-17 09:15:00 | SPY | ETF | 91.53 | 91.54 | 91.4 | 91.4 | 424962.0 |
| 2009-06-17 09:20:00 | SPY | ETF | 91.4 | 91.49 | 91.39 | 91.47 | 285371.0 |
| 2009-06-17 09:25:00 | SPY | ETF | 91.47 | 91.65 | 91.47 | 91.59 | 1078720.0 |
| 2009-06-17 09:30:00 | SPY | ETF | 91.6 | 91.74 | 91.51 | 91.62 | 6317258.0 |
| 2009-06-17 09:35:00 | SPY | ETF | 91.62 | 91.81 | 91.61 | 91.725 | 5946507.0 |
| 2009-06-17 09:40:00 | SPY | ETF | 91.73 | 91.75 | 91.41 | 91.45 | 3882722.0 |
| 2009-06-17 09:45:00 | SPY | ETF | 91.45 | 91.55 | 91.31 | 91.33 | 4977635.0 |
| 2009-06-17 09:50:00 | SPY | ETF | 91.32 | 91.45 | 91.3 | 91.3601 | 4865805.0 |
| 2009-06-17 09:55:00 | SPY | ETF | 91.3601 | 91.37 | 91.17 | 91.22 | 4309006.0 |
| 2009-06-17 10:00:00 | SPY | ETF | 91.22 | 91.37 | 91.14 | 91.34 | 4349807.0 |
> showing 50 of 29,752 rows — these rows as CSV