PREVIEW / etf_5min / 2011-04-14
file: by_date/etf_5min/2011/2011-04-14.parquet size: 866 KB rows: 35,910
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-14 05:30:00 | SPY | ETF | 131.01 | 131.01 | 130.88 | 130.88 | 1400.0 |
| 2011-04-14 05:35:00 | SPY | ETF | 130.86 | 130.86 | 130.77 | 130.77 | 5900.0 |
| 2011-04-14 05:40:00 | SPY | ETF | 130.75 | 130.75 | 130.75 | 130.75 | 5100.0 |
| 2011-04-14 05:45:00 | SPY | ETF | 130.83 | 130.85 | 130.83 | 130.85 | 600.0 |
| 2011-04-14 05:50:00 | SPY | ETF | 130.8 | 130.8 | 130.8 | 130.8 | 200.0 |
| 2011-04-14 05:55:00 | SPY | ETF | 130.77 | 130.77 | 130.62 | 130.67 | 1100.0 |
| 2011-04-14 06:00:00 | SPY | ETF | 130.63 | 130.65 | 130.63 | 130.65 | 5700.0 |
| 2011-04-14 06:05:00 | SPY | ETF | 130.62 | 130.68 | 130.62 | 130.68 | 900.0 |
| 2011-04-14 06:10:00 | SPY | ETF | 130.63 | 130.66 | 130.63 | 130.66 | 10500.0 |
| 2011-04-14 06:15:00 | SPY | ETF | 130.7 | 130.79 | 130.7 | 130.79 | 10200.0 |
| 2011-04-14 06:20:00 | SPY | ETF | 130.73 | 130.73 | 130.73 | 130.73 | 1600.0 |
| 2011-04-14 06:25:00 | SPY | ETF | 130.69 | 130.7 | 130.69 | 130.7 | 1300.0 |
| 2011-04-14 06:30:00 | SPY | ETF | 130.7 | 130.7 | 130.7 | 130.7 | 350.0 |
| 2011-04-14 06:40:00 | SPY | ETF | 130.75 | 130.75 | 130.62 | 130.68 | 4200.0 |
| 2011-04-14 06:45:00 | SPY | ETF | 130.65 | 130.65 | 130.62 | 130.62 | 1100.0 |
| 2011-04-14 06:50:00 | SPY | ETF | 130.63 | 130.7 | 130.63 | 130.65 | 1700.0 |
| 2011-04-14 06:55:00 | SPY | ETF | 130.63 | 130.67 | 130.61 | 130.61 | 16400.0 |
| 2011-04-14 07:00:00 | SPY | ETF | 130.65 | 130.65 | 130.58 | 130.59 | 9913.0 |
| 2011-04-14 07:05:00 | SPY | ETF | 130.6 | 130.62 | 130.58 | 130.58 | 10105.0 |
| 2011-04-14 07:10:00 | SPY | ETF | 130.59 | 130.61 | 130.54 | 130.6 | 25305.0 |
| 2011-04-14 07:15:00 | SPY | ETF | 130.58 | 130.64 | 130.58 | 130.64 | 8250.0 |
| 2011-04-14 07:20:00 | SPY | ETF | 130.66 | 130.69 | 130.63 | 130.67 | 38615.0 |
| 2011-04-14 07:25:00 | SPY | ETF | 130.68 | 130.72 | 130.66 | 130.67 | 67818.0 |
| 2011-04-14 07:30:00 | SPY | ETF | 130.69 | 130.73 | 130.69 | 130.72 | 44437.0 |
| 2011-04-14 07:35:00 | SPY | ETF | 130.72 | 130.77 | 130.72 | 130.73 | 29950.0 |
| 2011-04-14 07:40:00 | SPY | ETF | 130.72 | 130.76 | 130.72 | 130.74 | 21018.0 |
| 2011-04-14 07:45:00 | SPY | ETF | 130.76 | 130.76 | 130.71 | 130.74 | 75718.0 |
| 2011-04-14 07:50:00 | SPY | ETF | 130.74 | 130.77 | 130.74 | 130.77 | 6750.0 |
| 2011-04-14 07:55:00 | SPY | ETF | 130.77 | 130.85 | 130.77 | 130.8 | 18900.0 |
| 2011-04-14 08:00:00 | SPY | ETF | 130.8 | 130.87 | 130.78 | 130.87 | 75130.0 |
| 2011-04-14 08:05:00 | SPY | ETF | 130.87 | 130.87 | 130.77 | 130.77 | 250030.0 |
| 2011-04-14 08:10:00 | SPY | ETF | 130.79 | 130.82 | 130.75 | 130.81 | 23940.0 |
| 2011-04-14 08:15:00 | SPY | ETF | 130.82 | 130.84 | 130.78 | 130.78 | 74955.0 |
| 2011-04-14 08:20:00 | SPY | ETF | 130.78 | 130.79 | 130.72 | 130.77 | 87953.0 |
| 2011-04-14 08:25:00 | SPY | ETF | 130.78 | 130.96 | 130.75 | 130.83 | 154027.0 |
| 2011-04-14 08:30:00 | SPY | ETF | 130.82 | 130.83 | 130.43 | 130.57 | 1057299.0 |
| 2011-04-14 08:35:00 | SPY | ETF | 130.57 | 130.64 | 130.5 | 130.62 | 190044.0 |
| 2011-04-14 08:40:00 | SPY | ETF | 130.63 | 130.65 | 130.48 | 130.49 | 247678.0 |
| 2011-04-14 08:45:00 | SPY | ETF | 130.49 | 131.293 | 130.44 | 130.51 | 206817.0 |
| 2011-04-14 08:50:00 | SPY | ETF | 130.51 | 130.56 | 130.48 | 130.54 | 265623.0 |
| 2011-04-14 08:55:00 | SPY | ETF | 130.54 | 130.64 | 130.52 | 130.63 | 88994.0 |
| 2011-04-14 09:00:00 | SPY | ETF | 130.62 | 130.62 | 130.48 | 130.5 | 89911.0 |
| 2011-04-14 09:05:00 | SPY | ETF | 130.51 | 130.62 | 130.51 | 130.62 | 69951.0 |
| 2011-04-14 09:10:00 | SPY | ETF | 130.62 | 130.66 | 130.61 | 130.62 | 88334.0 |
| 2011-04-14 09:15:00 | SPY | ETF | 130.62 | 130.67 | 130.6 | 130.67 | 108421.0 |
| 2011-04-14 09:20:00 | SPY | ETF | 130.67 | 130.67 | 130.61 | 130.65 | 111288.0 |
| 2011-04-14 09:25:00 | SPY | ETF | 130.65 | 130.73 | 130.65 | 130.7 | 283321.0 |
| 2011-04-14 09:30:00 | SPY | ETF | 130.7 | 130.83 | 130.67 | 130.74 | 4573346.0 |
| 2011-04-14 09:35:00 | SPY | ETF | 130.74 | 130.86 | 130.71 | 130.79 | 3643078.0 |
| 2011-04-14 09:40:00 | SPY | ETF | 130.79 | 130.88 | 130.61 | 130.67 | 3328123.0 |
> showing 50 of 35,910 rows — these rows as CSV