PREVIEW / etf_5min / 2009-05-12
file: by_date/etf_5min/2009/2009-05-12.parquet size: 704 KB rows: 30,476
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-05-12 04:15:00 | SPY | ETF | 91.76 | 91.76 | 91.76 | 91.76 | 300.0 |
| 2009-05-12 04:20:00 | SPY | ETF | 91.89 | 91.92 | 91.89 | 91.92 | 1000.0 |
| 2009-05-12 04:25:00 | SPY | ETF | 91.89 | 91.89 | 91.89 | 91.89 | 1300.0 |
| 2009-05-12 04:30:00 | SPY | ETF | 91.9 | 91.9 | 91.86 | 91.89 | 1200.0 |
| 2009-05-12 04:35:00 | SPY | ETF | 91.84 | 91.84 | 91.82 | 91.82 | 600.0 |
| 2009-05-12 04:50:00 | SPY | ETF | 91.71 | 91.71 | 91.71 | 91.71 | 700.0 |
| 2009-05-12 04:55:00 | SPY | ETF | 91.69 | 91.69 | 91.69 | 91.69 | 100.0 |
| 2009-05-12 05:10:00 | SPY | ETF | 91.89 | 91.92 | 91.89 | 91.92 | 300.0 |
| 2009-05-12 05:45:00 | SPY | ETF | 91.71 | 91.71 | 91.71 | 91.71 | 100.0 |
| 2009-05-12 05:50:00 | SPY | ETF | 91.78 | 91.8 | 91.78 | 91.8 | 609.0 |
| 2009-05-12 06:00:00 | SPY | ETF | 91.75 | 91.75 | 91.69 | 91.69 | 2800.0 |
| 2009-05-12 06:10:00 | SPY | ETF | 91.71 | 91.71 | 91.71 | 91.71 | 9900.0 |
| 2009-05-12 06:15:00 | SPY | ETF | 91.71 | 91.71 | 91.64 | 91.64 | 10200.0 |
| 2009-05-12 06:25:00 | SPY | ETF | 91.55 | 91.59 | 91.55 | 91.59 | 40000.0 |
| 2009-05-12 06:30:00 | SPY | ETF | 91.48 | 91.48 | 91.48 | 91.48 | 5000.0 |
| 2009-05-12 06:35:00 | SPY | ETF | 91.46 | 91.46 | 91.44 | 91.44 | 2650.0 |
| 2009-05-12 06:40:00 | SPY | ETF | 91.48 | 91.5 | 91.48 | 91.5 | 5000.0 |
| 2009-05-12 06:50:00 | SPY | ETF | 91.47 | 91.47 | 91.38 | 91.38 | 1550.0 |
| 2009-05-12 06:55:00 | SPY | ETF | 91.38 | 91.41 | 91.28 | 91.34 | 9200.0 |
| 2009-05-12 07:00:00 | SPY | ETF | 91.31 | 91.35 | 91.3 | 91.31 | 17525.0 |
| 2009-05-12 07:05:00 | SPY | ETF | 91.31 | 91.42 | 91.31 | 91.4 | 81516.0 |
| 2009-05-12 07:10:00 | SPY | ETF | 91.42 | 91.42 | 91.38 | 91.42 | 25669.0 |
| 2009-05-12 07:15:00 | SPY | ETF | 91.39 | 91.44 | 91.38 | 91.44 | 18207.0 |
| 2009-05-12 07:20:00 | SPY | ETF | 91.43 | 91.49 | 91.43 | 91.49 | 24038.0 |
| 2009-05-12 07:25:00 | SPY | ETF | 91.51 | 91.57 | 91.5 | 91.53 | 20769.0 |
| 2009-05-12 07:30:00 | SPY | ETF | 91.53 | 91.55 | 91.52 | 91.52 | 47336.0 |
| 2009-05-12 07:35:00 | SPY | ETF | 91.53 | 91.55 | 91.5 | 91.5 | 16812.0 |
| 2009-05-12 07:40:00 | SPY | ETF | 91.5 | 91.62 | 91.47 | 91.62 | 156142.0 |
| 2009-05-12 07:45:00 | SPY | ETF | 91.63 | 91.69 | 91.63 | 91.69 | 292065.0 |
| 2009-05-12 07:50:00 | SPY | ETF | 91.68 | 91.69 | 91.65 | 91.69 | 181031.0 |
| 2009-05-12 07:55:00 | SPY | ETF | 91.66 | 91.71 | 91.65 | 91.68 | 38769.0 |
| 2009-05-12 08:00:00 | SPY | ETF | 91.68 | 91.82 | 90.8 | 91.79 | 506433.0 |
| 2009-05-12 08:05:00 | SPY | ETF | 91.77 | 91.82 | 91.76 | 91.8 | 315275.0 |
| 2009-05-12 08:10:00 | SPY | ETF | 91.79 | 92.0 | 91.32 | 91.77 | 750918.0 |
| 2009-05-12 08:15:00 | SPY | ETF | 91.77 | 91.89 | 91.76 | 91.84 | 80194.0 |
| 2009-05-12 08:20:00 | SPY | ETF | 91.84 | 91.93 | 91.84 | 91.89 | 260727.0 |
| 2009-05-12 08:25:00 | SPY | ETF | 91.9 | 91.91 | 91.85 | 91.87 | 120143.0 |
| 2009-05-12 08:30:00 | SPY | ETF | 91.86 | 91.86 | 91.72 | 91.74 | 223073.0 |
| 2009-05-12 08:35:00 | SPY | ETF | 91.74 | 91.87 | 91.73 | 91.87 | 145391.0 |
| 2009-05-12 08:40:00 | SPY | ETF | 91.88 | 91.9 | 91.84 | 91.88 | 149163.0 |
| 2009-05-12 08:45:00 | SPY | ETF | 91.88 | 91.9 | 91.85 | 91.87 | 110408.0 |
| 2009-05-12 08:50:00 | SPY | ETF | 91.86 | 91.86 | 91.72 | 91.74 | 203111.0 |
| 2009-05-12 08:55:00 | SPY | ETF | 91.74 | 91.78 | 91.71 | 91.77 | 154700.0 |
| 2009-05-12 09:00:00 | SPY | ETF | 91.76 | 91.77 | 91.7 | 91.72 | 107032.0 |
| 2009-05-12 09:05:00 | SPY | ETF | 91.71 | 91.71 | 91.58 | 91.61 | 281343.0 |
| 2009-05-12 09:10:00 | SPY | ETF | 91.61 | 91.64 | 91.6 | 91.6 | 71885.0 |
| 2009-05-12 09:15:00 | SPY | ETF | 91.6 | 91.64 | 91.57 | 91.61 | 170489.0 |
| 2009-05-12 09:20:00 | SPY | ETF | 91.61 | 91.67 | 91.61 | 91.66 | 44188.0 |
| 2009-05-12 09:25:00 | SPY | ETF | 91.66 | 91.69 | 91.63 | 91.64 | 141062.0 |
| 2009-05-12 09:30:00 | SPY | ETF | 91.63 | 91.83 | 91.59 | 91.7 | 4089829.0 |
> showing 50 of 30,476 rows — these rows as CSV