PREVIEW / etf_5min / 2009-03-06
file: by_date/etf_5min/2009/2009-03-06.parquet size: 716 KB rows: 31,002
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-06 04:15:00 | SPY | ETF | 69.41 | 69.41 | 69.41 | 69.41 | 300.0 |
| 2009-03-06 05:10:00 | SPY | ETF | 69.28 | 69.28 | 69.28 | 69.28 | 100.0 |
| 2009-03-06 05:20:00 | SPY | ETF | 69.1 | 69.1 | 69.1 | 69.1 | 100.0 |
| 2009-03-06 05:25:00 | SPY | ETF | 68.91 | 68.91 | 68.91 | 68.91 | 100.0 |
| 2009-03-06 05:30:00 | SPY | ETF | 68.89 | 68.89 | 68.89 | 68.89 | 100.0 |
| 2009-03-06 06:00:00 | SPY | ETF | 68.86 | 68.86 | 68.86 | 68.86 | 100.0 |
| 2009-03-06 06:05:00 | SPY | ETF | 68.9 | 68.9 | 68.9 | 68.9 | 2500.0 |
| 2009-03-06 06:10:00 | SPY | ETF | 68.74 | 68.74 | 68.67 | 68.67 | 2300.0 |
| 2009-03-06 06:15:00 | SPY | ETF | 68.63 | 68.63 | 68.46 | 68.53 | 101300.0 |
| 2009-03-06 06:20:00 | SPY | ETF | 68.38 | 68.53 | 68.38 | 68.48 | 2850.0 |
| 2009-03-06 06:25:00 | SPY | ETF | 68.56 | 68.62 | 68.54 | 68.59 | 11400.0 |
| 2009-03-06 06:30:00 | SPY | ETF | 68.63 | 68.63 | 68.63 | 68.63 | 5000.0 |
| 2009-03-06 06:35:00 | SPY | ETF | 68.58 | 68.63 | 68.58 | 68.63 | 25600.0 |
| 2009-03-06 06:40:00 | SPY | ETF | 68.66 | 68.66 | 68.66 | 68.66 | 2500.0 |
| 2009-03-06 06:45:00 | SPY | ETF | 68.66 | 68.66 | 68.66 | 68.66 | 2500.0 |
| 2009-03-06 06:50:00 | SPY | ETF | 68.72 | 68.82 | 68.72 | 68.82 | 118472.0 |
| 2009-03-06 06:55:00 | SPY | ETF | 68.86 | 68.86 | 68.85 | 68.85 | 100000.0 |
| 2009-03-06 07:00:00 | SPY | ETF | 68.9 | 69.02 | 68.9 | 68.95 | 48190.0 |
| 2009-03-06 07:05:00 | SPY | ETF | 69.0 | 69.03 | 68.91 | 68.91 | 398700.0 |
| 2009-03-06 07:10:00 | SPY | ETF | 68.94 | 68.95 | 68.86 | 68.87 | 59000.0 |
| 2009-03-06 07:15:00 | SPY | ETF | 68.81 | 68.89 | 68.75 | 68.75 | 76490.0 |
| 2009-03-06 07:20:00 | SPY | ETF | 68.75 | 68.75 | 68.64 | 68.64 | 382220.0 |
| 2009-03-06 07:25:00 | SPY | ETF | 68.63 | 68.7 | 68.63 | 68.63 | 356750.0 |
| 2009-03-06 07:30:00 | SPY | ETF | 68.63 | 68.77 | 68.62 | 68.74 | 273940.0 |
| 2009-03-06 07:35:00 | SPY | ETF | 68.75 | 68.76 | 68.7 | 68.75 | 67993.0 |
| 2009-03-06 07:40:00 | SPY | ETF | 68.78 | 68.78 | 68.6 | 68.61 | 444400.0 |
| 2009-03-06 07:45:00 | SPY | ETF | 68.64 | 68.79 | 68.62 | 68.79 | 360555.0 |
| 2009-03-06 07:50:00 | SPY | ETF | 68.79 | 68.79 | 68.73 | 68.75 | 101732.0 |
| 2009-03-06 07:55:00 | SPY | ETF | 68.73 | 68.78 | 68.73 | 68.77 | 113714.0 |
| 2009-03-06 08:00:00 | SPY | ETF | 68.85 | 68.91 | 68.7 | 68.88 | 1346680.0 |
| 2009-03-06 08:05:00 | SPY | ETF | 68.87 | 68.95 | 68.84 | 68.85 | 629356.0 |
| 2009-03-06 08:10:00 | SPY | ETF | 68.65 | 68.98 | 68.65 | 68.96 | 2267703.0 |
| 2009-03-06 08:15:00 | SPY | ETF | 68.98 | 69.16 | 68.98 | 69.08 | 793334.0 |
| 2009-03-06 08:20:00 | SPY | ETF | 69.08 | 69.2 | 69.07 | 69.17 | 938917.0 |
| 2009-03-06 08:25:00 | SPY | ETF | 69.17 | 69.23 | 68.88 | 69.11 | 1721762.0 |
| 2009-03-06 08:30:00 | SPY | ETF | 69.12 | 69.91 | 69.09 | 69.32 | 7675480.0 |
| 2009-03-06 08:35:00 | SPY | ETF | 69.33 | 69.44 | 69.03 | 69.22 | 1712083.0 |
| 2009-03-06 08:40:00 | SPY | ETF | 69.24 | 69.39 | 69.12 | 69.33 | 381133.0 |
| 2009-03-06 08:45:00 | SPY | ETF | 69.33 | 69.49 | 68.95 | 69.42 | 872533.0 |
| 2009-03-06 08:50:00 | SPY | ETF | 69.43 | 69.95 | 68.96 | 69.86 | 1191933.0 |
| 2009-03-06 08:55:00 | SPY | ETF | 69.86 | 69.9 | 69.64 | 69.69 | 1331036.0 |
| 2009-03-06 09:00:00 | SPY | ETF | 69.67 | 69.82 | 69.6 | 69.61 | 359810.0 |
| 2009-03-06 09:05:00 | SPY | ETF | 69.6 | 69.73 | 68.69 | 69.47 | 1028155.0 |
| 2009-03-06 09:10:00 | SPY | ETF | 69.47 | 69.53 | 69.36 | 69.37 | 311886.0 |
| 2009-03-06 09:15:00 | SPY | ETF | 69.36 | 69.5 | 69.34 | 69.46 | 340999.0 |
| 2009-03-06 09:20:00 | SPY | ETF | 69.45 | 69.55 | 69.34 | 69.5 | 434348.0 |
| 2009-03-06 09:25:00 | SPY | ETF | 69.5 | 69.52 | 69.36 | 69.41 | 925070.0 |
| 2009-03-06 09:30:00 | SPY | ETF | 69.4 | 69.48 | 69.09 | 69.12 | 11570710.0 |
| 2009-03-06 09:35:00 | SPY | ETF | 69.12 | 69.55 | 69.1 | 69.3893 | 10581826.0 |
| 2009-03-06 09:40:00 | SPY | ETF | 69.385 | 70.41 | 69.33 | 70.37 | 16242619.0 |
> showing 50 of 31,002 rows — these rows as CSV