PREVIEW / etf_5min / 2009-08-25
file: by_date/etf_5min/2009/2009-08-25.parquet size: 722 KB rows: 30,733
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-08-25 04:15:00 | SPY | ETF | 102.97 | 102.97 | 102.97 | 102.97 | 200.0 |
| 2009-08-25 04:40:00 | SPY | ETF | 102.89 | 102.89 | 102.87 | 102.87 | 1200.0 |
| 2009-08-25 04:45:00 | SPY | ETF | 102.93 | 102.93 | 102.93 | 102.93 | 100.0 |
| 2009-08-25 04:50:00 | SPY | ETF | 102.93 | 102.93 | 102.93 | 102.93 | 100.0 |
| 2009-08-25 05:00:00 | SPY | ETF | 103.08 | 103.08 | 103.08 | 103.08 | 200.0 |
| 2009-08-25 05:05:00 | SPY | ETF | 103.14 | 103.14 | 103.09 | 103.09 | 8000.0 |
| 2009-08-25 05:35:00 | SPY | ETF | 103.09 | 103.09 | 103.09 | 103.09 | 100.0 |
| 2009-08-25 06:15:00 | SPY | ETF | 103.09 | 103.11 | 103.09 | 103.11 | 1600.0 |
| 2009-08-25 06:25:00 | SPY | ETF | 103.09 | 103.09 | 103.07 | 103.07 | 14000.0 |
| 2009-08-25 06:30:00 | SPY | ETF | 103.04 | 103.04 | 103.02 | 103.02 | 601.0 |
| 2009-08-25 06:35:00 | SPY | ETF | 103.02 | 103.03 | 103.02 | 103.03 | 724.0 |
| 2009-08-25 06:40:00 | SPY | ETF | 103.01 | 103.01 | 103.01 | 103.01 | 1000.0 |
| 2009-08-25 06:50:00 | SPY | ETF | 102.99 | 102.99 | 102.99 | 102.99 | 171.0 |
| 2009-08-25 06:55:00 | SPY | ETF | 103.04 | 103.04 | 103.04 | 103.04 | 384.0 |
| 2009-08-25 07:00:00 | SPY | ETF | 103.05 | 103.05 | 103.04 | 103.04 | 5213.0 |
| 2009-08-25 07:05:00 | SPY | ETF | 103.06 | 103.06 | 103.02 | 103.06 | 4300.0 |
| 2009-08-25 07:10:00 | SPY | ETF | 103.0 | 103.06 | 103.0 | 103.06 | 2925.0 |
| 2009-08-25 07:15:00 | SPY | ETF | 103.09 | 103.12 | 103.08 | 103.09 | 7900.0 |
| 2009-08-25 07:20:00 | SPY | ETF | 103.09 | 103.16 | 103.09 | 103.16 | 9900.0 |
| 2009-08-25 07:25:00 | SPY | ETF | 103.14 | 103.14 | 103.11 | 103.12 | 11297.0 |
| 2009-08-25 07:30:00 | SPY | ETF | 103.14 | 103.15 | 103.14 | 103.15 | 42900.0 |
| 2009-08-25 07:35:00 | SPY | ETF | 103.15 | 103.21 | 103.15 | 103.19 | 172969.0 |
| 2009-08-25 07:40:00 | SPY | ETF | 103.2 | 103.22 | 103.18 | 103.18 | 121900.0 |
| 2009-08-25 07:45:00 | SPY | ETF | 103.2 | 103.21 | 103.16 | 103.16 | 15843.0 |
| 2009-08-25 07:50:00 | SPY | ETF | 103.18 | 103.3 | 103.18 | 103.3 | 25800.0 |
| 2009-08-25 07:55:00 | SPY | ETF | 103.25 | 103.48 | 103.25 | 103.48 | 407300.0 |
| 2009-08-25 08:00:00 | SPY | ETF | 103.48 | 103.48 | 102.65 | 103.43 | 560924.0 |
| 2009-08-25 08:05:00 | SPY | ETF | 103.43 | 103.49 | 103.43 | 103.47 | 251057.0 |
| 2009-08-25 08:10:00 | SPY | ETF | 103.48 | 103.59 | 103.46 | 103.54 | 345877.0 |
| 2009-08-25 08:15:00 | SPY | ETF | 103.54 | 103.59 | 103.53 | 103.54 | 155743.0 |
| 2009-08-25 08:20:00 | SPY | ETF | 103.54 | 103.56 | 103.47 | 103.49 | 334072.0 |
| 2009-08-25 08:25:00 | SPY | ETF | 103.48 | 103.49 | 103.43 | 103.44 | 312356.0 |
| 2009-08-25 08:30:00 | SPY | ETF | 103.45 | 103.45 | 103.41 | 103.42 | 72802.0 |
| 2009-08-25 08:35:00 | SPY | ETF | 103.43 | 103.51 | 103.4 | 103.4 | 550800.0 |
| 2009-08-25 08:40:00 | SPY | ETF | 103.4 | 103.48 | 102.77 | 103.47 | 83423.0 |
| 2009-08-25 08:45:00 | SPY | ETF | 103.46 | 103.54 | 103.45 | 103.52 | 227016.0 |
| 2009-08-25 08:50:00 | SPY | ETF | 103.52 | 103.53 | 103.48 | 103.51 | 66993.0 |
| 2009-08-25 08:55:00 | SPY | ETF | 103.51 | 103.54 | 103.49 | 103.51 | 115449.0 |
| 2009-08-25 09:00:00 | SPY | ETF | 103.52 | 103.72 | 103.51 | 103.51 | 1272513.0 |
| 2009-08-25 09:05:00 | SPY | ETF | 103.52 | 103.55 | 103.47 | 103.52 | 360515.0 |
| 2009-08-25 09:10:00 | SPY | ETF | 103.52 | 103.61 | 103.51 | 103.61 | 327468.0 |
| 2009-08-25 09:15:00 | SPY | ETF | 103.61 | 103.64 | 103.51 | 103.53 | 244841.0 |
| 2009-08-25 09:20:00 | SPY | ETF | 103.53 | 103.54 | 102.36 | 103.47 | 165923.0 |
| 2009-08-25 09:25:00 | SPY | ETF | 103.46 | 103.46 | 103.36 | 103.37 | 354572.0 |
| 2009-08-25 09:30:00 | SPY | ETF | 103.37 | 103.56 | 103.31 | 103.38 | 4000845.0 |
| 2009-08-25 09:35:00 | SPY | ETF | 103.39 | 103.42 | 103.12 | 103.24 | 4464605.0 |
| 2009-08-25 09:40:00 | SPY | ETF | 103.23 | 103.43 | 103.17 | 103.4101 | 3583396.0 |
| 2009-08-25 09:45:00 | SPY | ETF | 103.4199 | 103.58 | 103.36 | 103.49 | 2886954.0 |
| 2009-08-25 09:50:00 | SPY | ETF | 103.49 | 103.65 | 103.49 | 103.555 | 2135588.0 |
| 2009-08-25 09:55:00 | SPY | ETF | 103.56 | 103.79 | 103.54 | 103.68 | 3617935.0 |
> showing 50 of 30,733 rows — these rows as CSV