PREVIEW / etf_5min / 2009-06-29
file: by_date/etf_5min/2009/2009-06-29.parquet size: 624 KB rows: 27,609
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-29 04:05:00 | SPY | ETF | 91.84 | 91.84 | 91.84 | 91.84 | 800.0 |
| 2009-06-29 04:15:00 | SPY | ETF | 91.82 | 91.82 | 91.82 | 91.82 | 110.0 |
| 2009-06-29 04:20:00 | SPY | ETF | 91.7 | 91.7 | 91.7 | 91.7 | 200.0 |
| 2009-06-29 04:35:00 | SPY | ETF | 91.72 | 91.72 | 91.72 | 91.72 | 500.0 |
| 2009-06-29 05:15:00 | SPY | ETF | 91.75 | 91.75 | 91.75 | 91.75 | 200.0 |
| 2009-06-29 06:05:00 | SPY | ETF | 91.87 | 91.87 | 91.87 | 91.87 | 5000.0 |
| 2009-06-29 06:10:00 | SPY | ETF | 91.93 | 92.1 | 91.93 | 92.1 | 10550.0 |
| 2009-06-29 06:15:00 | SPY | ETF | 92.1 | 92.14 | 92.1 | 92.14 | 6600.0 |
| 2009-06-29 06:20:00 | SPY | ETF | 92.1 | 92.1 | 92.1 | 92.1 | 2600.0 |
| 2009-06-29 06:25:00 | SPY | ETF | 92.09 | 92.09 | 92.09 | 92.09 | 500.0 |
| 2009-06-29 06:50:00 | SPY | ETF | 92.14 | 92.14 | 92.14 | 92.14 | 300.0 |
| 2009-06-29 06:55:00 | SPY | ETF | 92.15 | 92.15 | 92.15 | 92.15 | 400.0 |
| 2009-06-29 07:00:00 | SPY | ETF | 92.15 | 92.15 | 92.11 | 92.11 | 19770.0 |
| 2009-06-29 07:05:00 | SPY | ETF | 92.1 | 92.17 | 92.1 | 92.13 | 285075.0 |
| 2009-06-29 07:10:00 | SPY | ETF | 92.13 | 92.13 | 92.05 | 92.05 | 34900.0 |
| 2009-06-29 07:15:00 | SPY | ETF | 92.06 | 92.1 | 92.06 | 92.1 | 26100.0 |
| 2009-06-29 07:20:00 | SPY | ETF | 92.11 | 92.14 | 92.07 | 92.14 | 270489.0 |
| 2009-06-29 07:25:00 | SPY | ETF | 92.1 | 92.19 | 92.08 | 92.19 | 192850.0 |
| 2009-06-29 07:30:00 | SPY | ETF | 92.19 | 92.25 | 92.19 | 92.21 | 45900.0 |
| 2009-06-29 07:35:00 | SPY | ETF | 92.22 | 92.23 | 92.22 | 92.23 | 102500.0 |
| 2009-06-29 07:40:00 | SPY | ETF | 92.24 | 92.24 | 92.15 | 92.17 | 116800.0 |
| 2009-06-29 07:45:00 | SPY | ETF | 92.16 | 92.16 | 92.09 | 92.11 | 24270.0 |
| 2009-06-29 07:50:00 | SPY | ETF | 92.11 | 92.11 | 92.09 | 92.11 | 19550.0 |
| 2009-06-29 07:55:00 | SPY | ETF | 92.11 | 92.25 | 92.1 | 92.22 | 208526.0 |
| 2009-06-29 08:00:00 | SPY | ETF | 92.22 | 92.3 | 92.07 | 92.2 | 705730.0 |
| 2009-06-29 08:05:00 | SPY | ETF | 92.2 | 92.23 | 92.15 | 92.21 | 247322.0 |
| 2009-06-29 08:10:00 | SPY | ETF | 92.23 | 92.28 | 92.23 | 92.26 | 54700.0 |
| 2009-06-29 08:15:00 | SPY | ETF | 92.26 | 92.32 | 92.26 | 92.26 | 403303.0 |
| 2009-06-29 08:20:00 | SPY | ETF | 92.26 | 92.31 | 92.23 | 92.27 | 145149.0 |
| 2009-06-29 08:25:00 | SPY | ETF | 92.26 | 92.26 | 92.23 | 92.24 | 56611.0 |
| 2009-06-29 08:30:00 | SPY | ETF | 92.24 | 92.24 | 92.13 | 92.16 | 99683.0 |
| 2009-06-29 08:35:00 | SPY | ETF | 92.16 | 92.17 | 92.14 | 92.17 | 76363.0 |
| 2009-06-29 08:40:00 | SPY | ETF | 92.17 | 92.19 | 92.15 | 92.16 | 184850.0 |
| 2009-06-29 08:45:00 | SPY | ETF | 92.17 | 92.17 | 92.06 | 92.09 | 78713.0 |
| 2009-06-29 08:50:00 | SPY | ETF | 92.1 | 92.17 | 92.1 | 92.13 | 113031.0 |
| 2009-06-29 08:55:00 | SPY | ETF | 92.14 | 92.14 | 92.05 | 92.09 | 119949.0 |
| 2009-06-29 09:00:00 | SPY | ETF | 92.09 | 92.13 | 92.08 | 92.12 | 52768.0 |
| 2009-06-29 09:05:00 | SPY | ETF | 92.12 | 92.15 | 92.11 | 92.14 | 53844.0 |
| 2009-06-29 09:10:00 | SPY | ETF | 92.14 | 92.18 | 92.13 | 92.16 | 72743.0 |
| 2009-06-29 09:15:00 | SPY | ETF | 92.16 | 92.2 | 92.15 | 92.18 | 56932.0 |
| 2009-06-29 09:20:00 | SPY | ETF | 92.17 | 92.2 | 92.15 | 92.17 | 58484.0 |
| 2009-06-29 09:25:00 | SPY | ETF | 92.18 | 92.18 | 92.1 | 92.11 | 210597.0 |
| 2009-06-29 09:30:00 | SPY | ETF | 92.11 | 92.2 | 92.02 | 92.14 | 5815320.0 |
| 2009-06-29 09:35:00 | SPY | ETF | 92.15 | 92.18 | 91.84 | 91.91 | 4598202.0 |
| 2009-06-29 09:40:00 | SPY | ETF | 91.9 | 92.07 | 91.84 | 91.999 | 3707134.0 |
| 2009-06-29 09:45:00 | SPY | ETF | 92.0 | 92.06 | 91.77 | 91.81 | 3489523.0 |
| 2009-06-29 09:50:00 | SPY | ETF | 91.81 | 91.83 | 91.7 | 91.71 | 2443538.0 |
| 2009-06-29 09:55:00 | SPY | ETF | 91.72 | 91.755 | 91.6 | 91.73 | 2594796.0 |
| 2009-06-29 10:00:00 | SPY | ETF | 91.73 | 91.83 | 91.715 | 91.75 | 2532203.0 |
| 2009-06-29 10:05:00 | SPY | ETF | 91.75 | 91.91 | 91.66 | 91.9 | 2546187.0 |
> showing 50 of 27,609 rows — these rows as CSV