PREVIEW / etf_5min / 2011-04-25
file: by_date/etf_5min/2011/2011-04-25.parquet size: 852 KB rows: 36,088
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 |
|---|---|---|---|---|---|---|---|
| 2011-04-25 04:00:00 | SPY | ETF | 133.85 | 133.85 | 133.85 | 133.85 | 300.0 |
| 2011-04-25 04:05:00 | SPY | ETF | 133.92 | 133.92 | 133.92 | 133.92 | 2000.0 |
| 2011-04-25 04:10:00 | SPY | ETF | 133.93 | 133.95 | 133.93 | 133.95 | 435.0 |
| 2011-04-25 04:45:00 | SPY | ETF | 133.91 | 133.91 | 133.91 | 133.91 | 100.0 |
| 2011-04-25 05:35:00 | SPY | ETF | 133.92 | 133.92 | 133.91 | 133.91 | 500.0 |
| 2011-04-25 06:25:00 | SPY | ETF | 133.92 | 133.92 | 133.91 | 133.91 | 300.0 |
| 2011-04-25 06:35:00 | SPY | ETF | 133.93 | 133.93 | 133.93 | 133.93 | 200.0 |
| 2011-04-25 06:40:00 | SPY | ETF | 133.9 | 133.9 | 133.9 | 133.9 | 21100.0 |
| 2011-04-25 06:50:00 | SPY | ETF | 133.94 | 133.94 | 133.94 | 133.94 | 1500.0 |
| 2011-04-25 07:00:00 | SPY | ETF | 133.95 | 133.96 | 133.93 | 133.93 | 7400.0 |
| 2011-04-25 07:05:00 | SPY | ETF | 133.93 | 133.94 | 133.92 | 133.92 | 3800.0 |
| 2011-04-25 07:10:00 | SPY | ETF | 133.94 | 133.94 | 133.94 | 133.94 | 1000.0 |
| 2011-04-25 07:15:00 | SPY | ETF | 133.94 | 133.96 | 133.92 | 133.94 | 18700.0 |
| 2011-04-25 07:20:00 | SPY | ETF | 133.94 | 133.94 | 133.92 | 133.92 | 16898.0 |
| 2011-04-25 07:25:00 | SPY | ETF | 133.96 | 133.96 | 133.94 | 133.94 | 5000.0 |
| 2011-04-25 07:30:00 | SPY | ETF | 133.94 | 133.94 | 133.92 | 133.92 | 12000.0 |
| 2011-04-25 07:35:00 | SPY | ETF | 133.92 | 133.94 | 133.92 | 133.94 | 5131.0 |
| 2011-04-25 07:40:00 | SPY | ETF | 133.94 | 133.96 | 133.93 | 133.96 | 2335.0 |
| 2011-04-25 07:45:00 | SPY | ETF | 133.94 | 133.94 | 133.92 | 133.92 | 2350.0 |
| 2011-04-25 07:50:00 | SPY | ETF | 133.9 | 133.93 | 133.9 | 133.91 | 53922.0 |
| 2011-04-25 07:55:00 | SPY | ETF | 133.9 | 133.92 | 133.88 | 133.91 | 5980.0 |
| 2011-04-25 08:00:00 | SPY | ETF | 133.93 | 133.93 | 133.87 | 133.89 | 59908.0 |
| 2011-04-25 08:05:00 | SPY | ETF | 133.89 | 133.89 | 133.86 | 133.88 | 9100.0 |
| 2011-04-25 08:10:00 | SPY | ETF | 133.88 | 133.88 | 133.86 | 133.86 | 7725.0 |
| 2011-04-25 08:15:00 | SPY | ETF | 133.86 | 133.88 | 133.85 | 133.88 | 16223.0 |
| 2011-04-25 08:20:00 | SPY | ETF | 133.87 | 133.91 | 133.86 | 133.9 | 15004.0 |
| 2011-04-25 08:25:00 | SPY | ETF | 133.89 | 133.9 | 133.8 | 133.81 | 24956.0 |
| 2011-04-25 08:30:00 | SPY | ETF | 133.79 | 133.81 | 133.74 | 133.77 | 42825.0 |
| 2011-04-25 08:35:00 | SPY | ETF | 133.77 | 133.78 | 133.6789 | 133.6789 | 109820.0 |
| 2011-04-25 08:40:00 | SPY | ETF | 133.74 | 133.75 | 133.72 | 133.74 | 52917.0 |
| 2011-04-25 08:45:00 | SPY | ETF | 133.74 | 133.74 | 133.7 | 133.73 | 34675.0 |
| 2011-04-25 08:50:00 | SPY | ETF | 133.73 | 133.73 | 133.61 | 133.65 | 116425.0 |
| 2011-04-25 08:55:00 | SPY | ETF | 133.65 | 133.69 | 133.64 | 133.67 | 49221.0 |
| 2011-04-25 09:00:00 | SPY | ETF | 133.68 | 133.7 | 133.67 | 133.69 | 35150.0 |
| 2011-04-25 09:05:00 | SPY | ETF | 133.7 | 133.72 | 133.68 | 133.72 | 72145.0 |
| 2011-04-25 09:10:00 | SPY | ETF | 133.71 | 133.74 | 133.7 | 133.74 | 66200.0 |
| 2011-04-25 09:15:00 | SPY | ETF | 133.74 | 133.76 | 133.73 | 133.75 | 20775.0 |
| 2011-04-25 09:20:00 | SPY | ETF | 133.74 | 133.74 | 133.71 | 133.72 | 18225.0 |
| 2011-04-25 09:25:00 | SPY | ETF | 133.71 | 133.72 | 133.62 | 133.68 | 287199.0 |
| 2011-04-25 09:30:00 | SPY | ETF | 133.68 | 133.75 | 133.63 | 133.655 | 2371806.0 |
| 2011-04-25 09:35:00 | SPY | ETF | 133.66 | 133.73 | 133.61 | 133.62 | 1563513.0 |
| 2011-04-25 09:40:00 | SPY | ETF | 133.62 | 133.64 | 133.49 | 133.57 | 1284996.0 |
| 2011-04-25 09:45:00 | SPY | ETF | 133.57 | 133.81 | 133.56 | 133.8 | 1253702.0 |
| 2011-04-25 09:50:00 | SPY | ETF | 133.79 | 133.86 | 133.66 | 133.67 | 1456418.0 |
| 2011-04-25 09:55:00 | SPY | ETF | 133.6785 | 133.78 | 133.64 | 133.76 | 642401.0 |
| 2011-04-25 10:00:00 | SPY | ETF | 133.76 | 133.83 | 133.71 | 133.71 | 1344500.0 |
| 2011-04-25 10:05:00 | SPY | ETF | 133.72 | 133.72 | 133.55 | 133.56 | 1371218.0 |
| 2011-04-25 10:10:00 | SPY | ETF | 133.57 | 133.58 | 133.52 | 133.57 | 1269589.0 |
| 2011-04-25 10:15:00 | SPY | ETF | 133.57 | 133.69 | 133.53 | 133.53 | 1139490.0 |
| 2011-04-25 10:20:00 | SPY | ETF | 133.53 | 133.54 | 133.32 | 133.36 | 1895799.0 |
> showing 50 of 36,088 rows — these rows as CSV