PREVIEW / etf_5min / 2010-12-08
file: by_date/etf_5min/2010/2010-12-08.parquet size: 855 KB rows: 36,020
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 |
|---|---|---|---|---|---|---|---|
| 2010-12-08 04:00:00 | SPY | ETF | 122.43 | 122.43 | 122.43 | 122.43 | 100.0 |
| 2010-12-08 04:10:00 | SPY | ETF | 122.4 | 122.4 | 122.4 | 122.4 | 100.0 |
| 2010-12-08 04:30:00 | SPY | ETF | 122.65 | 122.65 | 122.65 | 122.65 | 200.0 |
| 2010-12-08 04:55:00 | SPY | ETF | 122.78 | 122.78 | 122.75 | 122.75 | 1076.0 |
| 2010-12-08 05:50:00 | SPY | ETF | 122.65 | 122.7 | 122.65 | 122.67 | 2850.0 |
| 2010-12-08 06:05:00 | SPY | ETF | 122.67 | 122.67 | 122.67 | 122.67 | 360.0 |
| 2010-12-08 06:10:00 | SPY | ETF | 122.7 | 122.73 | 122.7 | 122.7 | 3500.0 |
| 2010-12-08 06:15:00 | SPY | ETF | 122.66 | 122.66 | 122.66 | 122.66 | 2000.0 |
| 2010-12-08 06:35:00 | SPY | ETF | 122.66 | 122.66 | 122.66 | 122.66 | 100.0 |
| 2010-12-08 06:45:00 | SPY | ETF | 122.69 | 122.69 | 122.69 | 122.69 | 500.0 |
| 2010-12-08 06:50:00 | SPY | ETF | 122.66 | 122.66 | 122.66 | 122.66 | 100.0 |
| 2010-12-08 06:55:00 | SPY | ETF | 122.61 | 122.61 | 122.61 | 122.61 | 100.0 |
| 2010-12-08 07:00:00 | SPY | ETF | 122.59 | 122.62 | 122.56 | 122.6 | 2000.0 |
| 2010-12-08 07:05:00 | SPY | ETF | 122.6 | 122.66 | 122.6 | 122.66 | 1000.0 |
| 2010-12-08 07:10:00 | SPY | ETF | 122.7 | 122.81 | 122.7 | 122.78 | 3900.0 |
| 2010-12-08 07:15:00 | SPY | ETF | 122.79 | 122.81 | 122.76 | 122.81 | 13125.0 |
| 2010-12-08 07:20:00 | SPY | ETF | 122.81 | 122.84 | 122.8 | 122.8 | 11960.0 |
| 2010-12-08 07:25:00 | SPY | ETF | 122.81 | 122.86 | 122.8 | 122.86 | 28190.0 |
| 2010-12-08 07:30:00 | SPY | ETF | 122.86 | 122.86 | 122.81 | 122.81 | 11570.0 |
| 2010-12-08 07:35:00 | SPY | ETF | 122.8 | 122.8 | 122.7 | 122.74 | 41700.0 |
| 2010-12-08 07:40:00 | SPY | ETF | 122.71 | 122.75 | 122.67 | 122.7 | 28600.0 |
| 2010-12-08 07:45:00 | SPY | ETF | 122.68 | 122.73 | 122.65 | 122.73 | 8690.0 |
| 2010-12-08 07:50:00 | SPY | ETF | 122.77 | 122.77 | 122.72 | 122.74 | 1800.0 |
| 2010-12-08 07:55:00 | SPY | ETF | 122.72 | 122.72 | 122.68 | 122.68 | 13100.0 |
| 2010-12-08 08:00:00 | SPY | ETF | 122.74 | 122.81 | 122.7 | 122.81 | 35888.0 |
| 2010-12-08 08:05:00 | SPY | ETF | 122.81 | 122.86 | 122.76 | 122.85 | 38630.0 |
| 2010-12-08 08:10:00 | SPY | ETF | 122.85 | 122.85 | 122.74 | 122.79 | 44046.0 |
| 2010-12-08 08:15:00 | SPY | ETF | 122.78 | 122.8 | 122.75 | 122.79 | 33125.0 |
| 2010-12-08 08:20:00 | SPY | ETF | 122.79 | 122.95 | 122.79 | 122.94 | 232164.0 |
| 2010-12-08 08:25:00 | SPY | ETF | 122.94 | 123.02 | 122.92 | 122.98 | 319898.0 |
| 2010-12-08 08:30:00 | SPY | ETF | 122.98 | 123.01 | 122.93 | 122.93 | 45210.0 |
| 2010-12-08 08:35:00 | SPY | ETF | 122.94 | 123.14 | 122.92 | 123.13 | 82753.0 |
| 2010-12-08 08:40:00 | SPY | ETF | 123.13 | 123.13 | 123.07 | 123.09 | 111879.0 |
| 2010-12-08 08:45:00 | SPY | ETF | 123.07 | 123.12 | 123.05 | 123.1 | 131989.0 |
| 2010-12-08 08:50:00 | SPY | ETF | 123.09 | 123.15 | 123.05 | 123.14 | 75666.0 |
| 2010-12-08 08:55:00 | SPY | ETF | 123.14 | 123.14 | 123.05 | 123.06 | 102510.0 |
| 2010-12-08 09:00:00 | SPY | ETF | 123.05 | 123.1 | 123.02 | 123.09 | 269173.0 |
| 2010-12-08 09:05:00 | SPY | ETF | 123.08 | 123.08 | 122.98 | 122.99 | 191224.0 |
| 2010-12-08 09:10:00 | SPY | ETF | 122.99 | 123.05 | 122.99 | 123.05 | 131941.0 |
| 2010-12-08 09:15:00 | SPY | ETF | 123.05 | 123.05 | 122.89 | 122.94 | 161222.0 |
| 2010-12-08 09:20:00 | SPY | ETF | 122.94 | 122.98 | 122.94 | 122.96 | 74776.0 |
| 2010-12-08 09:25:00 | SPY | ETF | 122.95 | 123.03 | 122.95 | 122.99 | 251778.0 |
| 2010-12-08 09:30:00 | SPY | ETF | 122.98 | 123.14 | 122.94 | 123.14 | 3103740.0 |
| 2010-12-08 09:35:00 | SPY | ETF | 123.14 | 123.26 | 123.12 | 123.15 | 2827647.0 |
| 2010-12-08 09:40:00 | SPY | ETF | 123.15 | 123.32 | 123.14 | 123.32 | 2501336.0 |
| 2010-12-08 09:45:00 | SPY | ETF | 123.31 | 123.38 | 123.2 | 123.215 | 1995308.0 |
| 2010-12-08 09:50:00 | SPY | ETF | 123.21 | 123.3 | 123.03 | 123.0496 | 2650941.0 |
| 2010-12-08 09:55:00 | SPY | ETF | 123.05 | 123.15 | 123.01 | 123.12 | 1370400.0 |
| 2010-12-08 10:00:00 | SPY | ETF | 123.11 | 123.13 | 122.95 | 123.01 | 1818030.0 |
| 2010-12-08 10:05:00 | SPY | ETF | 123.01 | 123.05 | 122.9 | 123.04 | 2843639.0 |
> showing 50 of 36,020 rows — these rows as CSV