PREVIEW / etf_5min / 2009-03-13
file: by_date/etf_5min/2009/2009-03-13.parquet size: 666 KB rows: 28,994
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-03-13 04:15:00 | SPY | ETF | 76.03 | 76.09 | 75.99 | 76.09 | 29856.0 |
| 2009-03-13 04:20:00 | SPY | ETF | 76.15 | 76.31 | 76.15 | 76.31 | 6000.0 |
| 2009-03-13 04:40:00 | SPY | ETF | 76.21 | 76.21 | 76.21 | 76.21 | 243.0 |
| 2009-03-13 04:50:00 | SPY | ETF | 76.14 | 76.14 | 76.11 | 76.11 | 200.0 |
| 2009-03-13 04:55:00 | SPY | ETF | 76.21 | 76.21 | 76.21 | 76.21 | 600.0 |
| 2009-03-13 05:00:00 | SPY | ETF | 76.22 | 76.22 | 76.22 | 76.22 | 300.0 |
| 2009-03-13 05:05:00 | SPY | ETF | 76.23 | 76.23 | 76.23 | 76.23 | 100.0 |
| 2009-03-13 05:40:00 | SPY | ETF | 76.08 | 76.08 | 76.03 | 76.06 | 50000.0 |
| 2009-03-13 05:45:00 | SPY | ETF | 76.0 | 76.07 | 76.0 | 76.07 | 17500.0 |
| 2009-03-13 05:50:00 | SPY | ETF | 76.05 | 76.05 | 76.05 | 76.05 | 230.0 |
| 2009-03-13 06:00:00 | SPY | ETF | 76.05 | 76.05 | 76.05 | 76.05 | 2000.0 |
| 2009-03-13 06:05:00 | SPY | ETF | 76.02 | 76.13 | 76.02 | 76.13 | 12500.0 |
| 2009-03-13 06:10:00 | SPY | ETF | 76.16 | 76.16 | 76.16 | 76.16 | 500.0 |
| 2009-03-13 06:15:00 | SPY | ETF | 76.15 | 76.15 | 76.15 | 76.15 | 1350.0 |
| 2009-03-13 06:20:00 | SPY | ETF | 76.07 | 76.07 | 76.07 | 76.07 | 500.0 |
| 2009-03-13 06:25:00 | SPY | ETF | 76.14 | 76.14 | 76.12 | 76.12 | 5200.0 |
| 2009-03-13 06:30:00 | SPY | ETF | 76.07 | 76.11 | 76.07 | 76.11 | 2900.0 |
| 2009-03-13 06:35:00 | SPY | ETF | 76.1 | 76.1 | 76.1 | 76.1 | 200.0 |
| 2009-03-13 06:45:00 | SPY | ETF | 76.07 | 76.2 | 76.07 | 76.2 | 5700.0 |
| 2009-03-13 06:50:00 | SPY | ETF | 76.12 | 76.2 | 76.12 | 76.2 | 4700.0 |
| 2009-03-13 06:55:00 | SPY | ETF | 76.19 | 76.34 | 76.19 | 76.34 | 10893.0 |
| 2009-03-13 07:00:00 | SPY | ETF | 76.42 | 76.46 | 76.3 | 76.3 | 82858.0 |
| 2009-03-13 07:05:00 | SPY | ETF | 76.3 | 76.59 | 76.28 | 76.59 | 102313.0 |
| 2009-03-13 07:10:00 | SPY | ETF | 76.54 | 76.59 | 76.47 | 76.47 | 52400.0 |
| 2009-03-13 07:15:00 | SPY | ETF | 76.48 | 76.48 | 76.4 | 76.42 | 23996.0 |
| 2009-03-13 07:20:00 | SPY | ETF | 76.4 | 76.45 | 76.4 | 76.44 | 25600.0 |
| 2009-03-13 07:25:00 | SPY | ETF | 76.44 | 76.45 | 76.26 | 76.28 | 20076.0 |
| 2009-03-13 07:30:00 | SPY | ETF | 76.27 | 76.3 | 76.23 | 76.23 | 123959.0 |
| 2009-03-13 07:35:00 | SPY | ETF | 76.25 | 76.26 | 76.18 | 76.21 | 131066.0 |
| 2009-03-13 07:40:00 | SPY | ETF | 76.21 | 76.41 | 76.21 | 76.41 | 89514.0 |
| 2009-03-13 07:45:00 | SPY | ETF | 76.38 | 76.42 | 76.3 | 76.3 | 91781.0 |
| 2009-03-13 07:50:00 | SPY | ETF | 76.32 | 76.32 | 76.23 | 76.27 | 125250.0 |
| 2009-03-13 07:55:00 | SPY | ETF | 76.28 | 76.31 | 76.25 | 76.3 | 42708.0 |
| 2009-03-13 08:00:00 | SPY | ETF | 76.3 | 76.44 | 75.4698 | 76.41 | 405506.0 |
| 2009-03-13 08:05:00 | SPY | ETF | 76.4 | 76.4 | 76.0 | 76.36 | 286794.0 |
| 2009-03-13 08:10:00 | SPY | ETF | 76.35 | 76.38 | 76.2 | 76.2 | 140902.0 |
| 2009-03-13 08:15:00 | SPY | ETF | 76.2 | 76.29 | 76.18 | 76.28 | 102935.0 |
| 2009-03-13 08:20:00 | SPY | ETF | 76.28 | 76.32 | 76.22 | 76.31 | 155899.0 |
| 2009-03-13 08:25:00 | SPY | ETF | 76.31 | 76.41 | 76.3 | 76.4 | 271746.0 |
| 2009-03-13 08:30:00 | SPY | ETF | 76.42 | 76.45 | 76.28 | 76.45 | 982586.0 |
| 2009-03-13 08:35:00 | SPY | ETF | 76.45 | 76.51 | 75.53 | 76.5 | 581919.0 |
| 2009-03-13 08:40:00 | SPY | ETF | 76.5 | 76.5 | 76.35 | 76.36 | 279245.0 |
| 2009-03-13 08:45:00 | SPY | ETF | 76.36 | 76.43 | 76.13 | 76.15 | 609867.0 |
| 2009-03-13 08:50:00 | SPY | ETF | 76.14 | 76.15 | 76.05 | 76.05 | 828399.0 |
| 2009-03-13 08:55:00 | SPY | ETF | 76.05 | 76.05 | 75.9 | 75.96 | 290932.0 |
| 2009-03-13 09:00:00 | SPY | ETF | 75.96 | 76.08 | 75.94 | 75.96 | 409002.0 |
| 2009-03-13 09:05:00 | SPY | ETF | 75.95 | 76.09 | 75.95 | 76.05 | 278994.0 |
| 2009-03-13 09:10:00 | SPY | ETF | 76.04 | 76.06 | 76.0 | 76.03 | 174701.0 |
| 2009-03-13 09:15:00 | SPY | ETF | 76.02 | 76.03 | 75.92 | 76.01 | 253962.0 |
| 2009-03-13 09:20:00 | SPY | ETF | 76.02 | 76.04 | 76.0 | 76.03 | 129154.0 |
> showing 50 of 28,994 rows — these rows as CSV