PREVIEW / etf_5min / 2005-09-30
file: by_date/etf_5min/2005/2005-09-30.parquet size: 126 KB rows: 7,090
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 |
|---|---|---|---|---|---|---|---|
| 2005-09-30 07:35:00 | SPY | ETF | 122.61 | 122.61 | 122.61 | 122.61 | 25000.0 |
| 2005-09-30 07:55:00 | SPY | ETF | 122.64 | 122.64 | 122.64 | 122.64 | 7500.0 |
| 2005-09-30 08:00:00 | SPY | ETF | 122.58 | 122.65 | 122.58 | 122.65 | 316400.0 |
| 2005-09-30 08:05:00 | SPY | ETF | 122.67 | 122.67 | 122.67 | 122.67 | 500.0 |
| 2005-09-30 08:10:00 | SPY | ETF | 122.68 | 122.68 | 122.68 | 122.68 | 4800.0 |
| 2005-09-30 08:15:00 | SPY | ETF | 122.7 | 122.71 | 122.7 | 122.71 | 12500.0 |
| 2005-09-30 08:20:00 | SPY | ETF | 122.71 | 122.74 | 122.7 | 122.73 | 134200.0 |
| 2005-09-30 08:30:00 | SPY | ETF | 122.67 | 122.67 | 122.55 | 122.57 | 92300.0 |
| 2005-09-30 08:35:00 | SPY | ETF | 122.57 | 123.58 | 122.57 | 122.58 | 140300.0 |
| 2005-09-30 08:40:00 | SPY | ETF | 122.62 | 122.62 | 122.55 | 122.58 | 31400.0 |
| 2005-09-30 08:45:00 | SPY | ETF | 122.58 | 122.6 | 122.58 | 122.6 | 6900.0 |
| 2005-09-30 08:50:00 | SPY | ETF | 122.58 | 122.64 | 122.58 | 122.64 | 11000.0 |
| 2005-09-30 08:55:00 | SPY | ETF | 122.66 | 122.67 | 122.66 | 122.66 | 20500.0 |
| 2005-09-30 09:00:00 | SPY | ETF | 122.57 | 122.58 | 122.57 | 122.58 | 11000.0 |
| 2005-09-30 09:05:00 | SPY | ETF | 122.58 | 122.58 | 122.58 | 122.58 | 100.0 |
| 2005-09-30 09:10:00 | SPY | ETF | 122.61 | 122.63 | 122.6 | 122.62 | 40000.0 |
| 2005-09-30 09:15:00 | SPY | ETF | 122.63 | 122.66 | 122.63 | 122.64 | 15500.0 |
| 2005-09-30 09:20:00 | SPY | ETF | 122.64 | 122.66 | 122.62 | 122.65 | 17200.0 |
| 2005-09-30 09:25:00 | SPY | ETF | 122.63 | 122.63 | 122.6 | 122.6 | 13300.0 |
| 2005-09-30 09:30:00 | SPY | ETF | 122.62 | 122.65 | 122.54 | 122.63 | 633300.0 |
| 2005-09-30 09:35:00 | SPY | ETF | 122.64 | 122.71 | 122.54 | 122.54 | 1052600.0 |
| 2005-09-30 09:40:00 | SPY | ETF | 122.54 | 122.64 | 122.52 | 122.62 | 533100.0 |
| 2005-09-30 09:45:00 | SPY | ETF | 122.57 | 122.64 | 122.51 | 122.61 | 1090800.0 |
| 2005-09-30 09:50:00 | SPY | ETF | 122.61 | 122.63 | 122.48 | 122.51 | 653400.0 |
| 2005-09-30 09:55:00 | SPY | ETF | 122.5 | 122.76 | 122.45 | 122.73 | 1804900.0 |
| 2005-09-30 10:00:00 | SPY | ETF | 122.76 | 122.78 | 122.52 | 122.55 | 1527200.0 |
| 2005-09-30 10:05:00 | SPY | ETF | 122.6212 | 122.82 | 122.6 | 122.76 | 996100.0 |
| 2005-09-30 10:10:00 | SPY | ETF | 122.76 | 122.77 | 122.58 | 122.61 | 762400.0 |
| 2005-09-30 10:15:00 | SPY | ETF | 122.61 | 122.65 | 122.53 | 122.63 | 666800.0 |
| 2005-09-30 10:20:00 | SPY | ETF | 122.64 | 122.79 | 122.61 | 122.76 | 575500.0 |
| 2005-09-30 10:25:00 | SPY | ETF | 122.77 | 122.78 | 122.67 | 122.74 | 261800.0 |
| 2005-09-30 10:30:00 | SPY | ETF | 122.73 | 122.77 | 122.67 | 122.73 | 204600.0 |
| 2005-09-30 10:35:00 | SPY | ETF | 122.71 | 122.75 | 122.62 | 122.69 | 451400.0 |
| 2005-09-30 10:40:00 | SPY | ETF | 122.69 | 122.85 | 122.69 | 122.83 | 722500.0 |
| 2005-09-30 10:45:00 | SPY | ETF | 122.83 | 122.97 | 122.83 | 122.85 | 2306500.0 |
| 2005-09-30 10:50:00 | SPY | ETF | 122.86 | 122.93 | 122.85 | 122.9 | 675500.0 |
| 2005-09-30 10:55:00 | SPY | ETF | 122.89 | 122.97 | 122.83 | 122.85 | 724900.0 |
| 2005-09-30 11:00:00 | SPY | ETF | 122.85 | 122.89 | 122.72 | 122.78 | 1709500.0 |
| 2005-09-30 11:05:00 | SPY | ETF | 122.76 | 122.78 | 122.71 | 122.72 | 300500.0 |
| 2005-09-30 11:10:00 | SPY | ETF | 122.72 | 122.79 | 122.71 | 122.7685 | 329500.0 |
| 2005-09-30 11:15:00 | SPY | ETF | 122.76 | 122.78 | 122.72 | 122.76 | 446500.0 |
| 2005-09-30 11:20:00 | SPY | ETF | 122.76 | 122.77 | 122.66 | 122.67 | 534600.0 |
| 2005-09-30 11:25:00 | SPY | ETF | 122.66 | 122.74 | 122.63 | 122.71 | 460300.0 |
| 2005-09-30 11:30:00 | SPY | ETF | 122.7 | 122.79 | 122.69 | 122.78 | 404200.0 |
| 2005-09-30 11:35:00 | SPY | ETF | 122.7715 | 122.79 | 122.73 | 122.78 | 299200.0 |
| 2005-09-30 11:40:00 | SPY | ETF | 122.78 | 122.79 | 122.73 | 122.75 | 167400.0 |
| 2005-09-30 11:45:00 | SPY | ETF | 122.75 | 122.78 | 122.65 | 122.65 | 591500.0 |
| 2005-09-30 11:50:00 | SPY | ETF | 122.64 | 122.66 | 122.59 | 122.59 | 851700.0 |
| 2005-09-30 11:55:00 | SPY | ETF | 122.59 | 122.61 | 122.52 | 122.6 | 427700.0 |
| 2005-09-30 12:00:00 | SPY | ETF | 122.59 | 122.61 | 122.53 | 122.57 | 303500.0 |
> showing 50 of 7,090 rows — these rows as CSV