PREVIEW / etf_5min / 2012-10-03
file: by_date/etf_5min/2012/2012-10-03.parquet size: 855 KB rows: 35,651
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 |
|---|---|---|---|---|---|---|---|
| 2012-10-03 04:00:00 | SPY | ETF | 144.19 | 144.46 | 144.19 | 144.46 | 647.0 |
| 2012-10-03 04:10:00 | SPY | ETF | 144.66 | 144.69 | 144.66 | 144.66 | 1389.0 |
| 2012-10-03 04:30:00 | SPY | ETF | 144.55 | 144.55 | 144.55 | 144.55 | 300.0 |
| 2012-10-03 04:55:00 | SPY | ETF | 144.55 | 144.55 | 144.55 | 144.55 | 200.0 |
| 2012-10-03 05:05:00 | SPY | ETF | 144.63 | 144.63 | 144.63 | 144.63 | 200.0 |
| 2012-10-03 05:15:00 | SPY | ETF | 144.61 | 144.61 | 144.61 | 144.61 | 100.0 |
| 2012-10-03 05:25:00 | SPY | ETF | 144.77 | 144.82 | 144.77 | 144.82 | 200.0 |
| 2012-10-03 05:35:00 | SPY | ETF | 144.75 | 144.77 | 144.75 | 144.77 | 490.0 |
| 2012-10-03 05:45:00 | SPY | ETF | 144.81 | 144.81 | 144.81 | 144.81 | 400.0 |
| 2012-10-03 05:55:00 | SPY | ETF | 144.76 | 144.76 | 144.76 | 144.76 | 100.0 |
| 2012-10-03 06:05:00 | SPY | ETF | 144.74 | 144.8 | 144.74 | 144.8 | 6500.0 |
| 2012-10-03 06:10:00 | SPY | ETF | 144.72 | 144.72 | 144.72 | 144.72 | 100.0 |
| 2012-10-03 06:20:00 | SPY | ETF | 144.7 | 144.7 | 144.7 | 144.7 | 133.0 |
| 2012-10-03 06:30:00 | SPY | ETF | 144.71 | 144.71 | 144.71 | 144.71 | 100.0 |
| 2012-10-03 06:35:00 | SPY | ETF | 144.65 | 144.65 | 144.65 | 144.65 | 500.0 |
| 2012-10-03 06:45:00 | SPY | ETF | 144.63 | 144.63 | 144.63 | 144.63 | 200.0 |
| 2012-10-03 06:50:00 | SPY | ETF | 144.59 | 144.59 | 144.57 | 144.57 | 5400.0 |
| 2012-10-03 07:00:00 | SPY | ETF | 144.62 | 144.63 | 144.58 | 144.63 | 1300.0 |
| 2012-10-03 07:05:00 | SPY | ETF | 144.63 | 144.63 | 144.57 | 144.62 | 18300.0 |
| 2012-10-03 07:10:00 | SPY | ETF | 144.58 | 144.58 | 144.58 | 144.58 | 100.0 |
| 2012-10-03 07:15:00 | SPY | ETF | 144.59 | 144.6 | 144.55 | 144.6 | 75500.0 |
| 2012-10-03 07:20:00 | SPY | ETF | 144.6 | 144.67 | 144.6 | 144.67 | 336355.0 |
| 2012-10-03 07:25:00 | SPY | ETF | 144.67 | 144.68 | 144.65 | 144.68 | 1400.0 |
| 2012-10-03 07:30:00 | SPY | ETF | 144.68 | 144.73 | 144.67 | 144.68 | 14800.0 |
| 2012-10-03 07:35:00 | SPY | ETF | 144.68 | 144.69 | 144.64 | 144.67 | 8700.0 |
| 2012-10-03 07:40:00 | SPY | ETF | 144.67 | 144.72 | 144.67 | 144.7 | 10400.0 |
| 2012-10-03 07:45:00 | SPY | ETF | 144.72 | 144.72 | 144.7 | 144.72 | 9200.0 |
| 2012-10-03 07:50:00 | SPY | ETF | 144.72 | 144.72 | 144.67 | 144.67 | 6000.0 |
| 2012-10-03 07:55:00 | SPY | ETF | 144.67 | 144.67 | 144.65 | 144.67 | 3800.0 |
| 2012-10-03 08:00:00 | SPY | ETF | 144.68 | 144.72 | 144.68 | 144.7 | 26171.0 |
| 2012-10-03 08:05:00 | SPY | ETF | 144.625 | 144.71 | 144.625 | 144.71 | 814350.0 |
| 2012-10-03 08:10:00 | SPY | ETF | 144.71 | 144.77 | 144.7 | 144.74 | 116242.0 |
| 2012-10-03 08:15:00 | SPY | ETF | 144.74 | 144.95 | 144.74 | 144.88 | 131150.0 |
| 2012-10-03 08:20:00 | SPY | ETF | 144.87 | 144.93 | 144.85 | 144.9 | 78675.0 |
| 2012-10-03 08:25:00 | SPY | ETF | 144.88 | 144.96 | 144.86 | 144.88 | 32450.0 |
| 2012-10-03 08:30:00 | SPY | ETF | 144.88 | 144.89 | 144.77 | 144.8 | 182885.0 |
| 2012-10-03 08:35:00 | SPY | ETF | 144.79 | 144.87 | 144.77 | 144.81 | 46304.0 |
| 2012-10-03 08:40:00 | SPY | ETF | 144.8 | 144.82 | 144.64 | 144.67 | 74040.0 |
| 2012-10-03 08:45:00 | SPY | ETF | 144.68 | 144.75 | 144.66 | 144.71 | 98205.0 |
| 2012-10-03 08:50:00 | SPY | ETF | 144.72 | 144.76 | 144.7 | 144.71 | 121493.0 |
| 2012-10-03 08:55:00 | SPY | ETF | 144.72 | 144.9 | 144.72 | 144.85 | 147303.0 |
| 2012-10-03 09:00:00 | SPY | ETF | 144.87 | 144.93 | 144.5 | 144.83 | 83383.0 |
| 2012-10-03 09:05:00 | SPY | ETF | 144.83 | 144.84 | 144.77 | 144.83 | 73672.0 |
| 2012-10-03 09:10:00 | SPY | ETF | 144.83 | 144.91 | 144.81 | 144.86 | 82991.0 |
| 2012-10-03 09:15:00 | SPY | ETF | 144.87 | 144.9 | 144.86 | 144.88 | 58821.0 |
| 2012-10-03 09:20:00 | SPY | ETF | 144.88 | 144.92 | 144.85 | 144.86 | 181730.0 |
| 2012-10-03 09:25:00 | SPY | ETF | 144.86 | 144.92 | 144.85 | 144.89 | 211108.0 |
| 2012-10-03 09:30:00 | SPY | ETF | 144.89 | 144.89 | 144.761 | 144.7817 | 2213061.0 |
| 2012-10-03 09:35:00 | SPY | ETF | 144.79 | 144.84 | 144.61 | 144.61 | 1863520.0 |
| 2012-10-03 09:40:00 | SPY | ETF | 144.61 | 144.68 | 144.51 | 144.51 | 2463262.0 |
> showing 50 of 35,651 rows — these rows as CSV