PREVIEW / etf_5min / 2008-03-07
file: by_date/etf_5min/2008/2008-03-07.parquet size: 505 KB rows: 23,802
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 |
|---|---|---|---|---|---|---|---|
| 2008-03-07 04:05:00 | SPY | ETF | 130.38 | 130.38 | 130.38 | 130.38 | 500.0 |
| 2008-03-07 04:15:00 | SPY | ETF | 130.41 | 130.42 | 130.41 | 130.41 | 1300.0 |
| 2008-03-07 05:15:00 | SPY | ETF | 130.81 | 130.81 | 130.81 | 130.81 | 1000.0 |
| 2008-03-07 05:30:00 | SPY | ETF | 130.69 | 130.69 | 130.69 | 130.69 | 10000.0 |
| 2008-03-07 05:50:00 | SPY | ETF | 130.65 | 130.65 | 130.65 | 130.65 | 3000.0 |
| 2008-03-07 06:15:00 | SPY | ETF | 130.6 | 130.6 | 130.6 | 130.6 | 100.0 |
| 2008-03-07 06:35:00 | SPY | ETF | 130.62 | 130.64 | 130.55 | 130.59 | 66100.0 |
| 2008-03-07 06:40:00 | SPY | ETF | 130.59 | 130.59 | 130.59 | 130.59 | 14900.0 |
| 2008-03-07 06:45:00 | SPY | ETF | 130.6 | 130.6 | 130.6 | 130.6 | 1000.0 |
| 2008-03-07 06:50:00 | SPY | ETF | 130.59 | 130.6 | 130.59 | 130.6 | 5000.0 |
| 2008-03-07 06:55:00 | SPY | ETF | 130.6 | 130.7 | 130.6 | 130.7 | 25000.0 |
| 2008-03-07 07:00:00 | SPY | ETF | 130.7 | 130.94 | 130.7 | 130.86 | 138900.0 |
| 2008-03-07 07:05:00 | SPY | ETF | 130.9 | 131.02 | 130.87 | 131.02 | 93900.0 |
| 2008-03-07 07:10:00 | SPY | ETF | 131.05 | 131.13 | 131.04 | 131.11 | 70600.0 |
| 2008-03-07 07:15:00 | SPY | ETF | 131.12 | 131.21 | 131.12 | 131.21 | 51600.0 |
| 2008-03-07 07:20:00 | SPY | ETF | 131.24 | 131.34 | 131.19 | 131.31 | 190800.0 |
| 2008-03-07 07:25:00 | SPY | ETF | 131.29 | 131.32 | 131.24 | 131.3 | 132200.0 |
| 2008-03-07 07:30:00 | SPY | ETF | 131.35 | 131.35 | 131.24 | 131.28 | 25700.0 |
| 2008-03-07 07:35:00 | SPY | ETF | 131.22 | 131.27 | 131.22 | 131.27 | 56800.0 |
| 2008-03-07 07:40:00 | SPY | ETF | 131.25 | 131.4 | 131.25 | 131.4 | 102100.0 |
| 2008-03-07 07:45:00 | SPY | ETF | 131.36 | 131.41 | 131.28 | 131.31 | 36400.0 |
| 2008-03-07 07:50:00 | SPY | ETF | 131.32 | 131.43 | 131.29 | 131.37 | 48600.0 |
| 2008-03-07 07:55:00 | SPY | ETF | 131.36 | 131.43 | 131.32 | 131.33 | 63600.0 |
| 2008-03-07 08:00:00 | SPY | ETF | 130.95 | 131.4 | 130.92 | 131.3 | 481800.0 |
| 2008-03-07 08:05:00 | SPY | ETF | 131.28 | 131.33 | 131.2 | 131.28 | 804400.0 |
| 2008-03-07 08:10:00 | SPY | ETF | 131.28 | 131.29 | 130.89 | 131.2 | 1169400.0 |
| 2008-03-07 08:15:00 | SPY | ETF | 131.18 | 132.09 | 131.12 | 131.12 | 6904100.0 |
| 2008-03-07 08:20:00 | SPY | ETF | 131.11 | 131.11 | 130.45 | 130.6 | 2956700.0 |
| 2008-03-07 08:25:00 | SPY | ETF | 130.59 | 131.2 | 130.03 | 130.76 | 2416400.0 |
| 2008-03-07 08:30:00 | SPY | ETF | 130.76 | 130.76 | 129.53 | 129.99 | 7645799.0 |
| 2008-03-07 08:35:00 | SPY | ETF | 129.99 | 130.0 | 129.35 | 129.43 | 2011200.0 |
| 2008-03-07 08:40:00 | SPY | ETF | 129.44 | 129.68 | 129.13 | 129.57 | 2035400.0 |
| 2008-03-07 08:45:00 | SPY | ETF | 129.59 | 129.73 | 129.49 | 129.68 | 1232000.0 |
| 2008-03-07 08:50:00 | SPY | ETF | 129.68 | 129.8 | 129.53 | 129.75 | 1144600.0 |
| 2008-03-07 08:55:00 | SPY | ETF | 129.73 | 129.98 | 129.72 | 129.94 | 903200.0 |
| 2008-03-07 09:00:00 | SPY | ETF | 129.95 | 129.98 | 129.74 | 129.8 | 901762.0 |
| 2008-03-07 09:05:00 | SPY | ETF | 129.8 | 129.88 | 129.64 | 129.77 | 690700.0 |
| 2008-03-07 09:10:00 | SPY | ETF | 129.76 | 129.76 | 129.48 | 129.61 | 533400.0 |
| 2008-03-07 09:15:00 | SPY | ETF | 129.63 | 129.64 | 129.5 | 129.58 | 790400.0 |
| 2008-03-07 09:20:00 | SPY | ETF | 129.58 | 129.87 | 129.58 | 129.83 | 311700.0 |
| 2008-03-07 09:25:00 | SPY | ETF | 129.83 | 129.87 | 129.6 | 129.7 | 504300.0 |
| 2008-03-07 09:30:00 | SPY | ETF | 129.73 | 129.97 | 129.445 | 129.56 | 6248444.0 |
| 2008-03-07 09:35:00 | SPY | ETF | 129.56 | 130.17 | 129.5599 | 130.09 | 6010364.0 |
| 2008-03-07 09:40:00 | SPY | ETF | 130.09 | 130.36 | 129.83 | 130.29 | 6959745.0 |
| 2008-03-07 09:45:00 | SPY | ETF | 130.29 | 130.66 | 129.8 | 130.61 | 8275807.0 |
| 2008-03-07 09:50:00 | SPY | ETF | 130.61 | 130.65 | 130.37 | 130.53 | 6073335.0 |
| 2008-03-07 09:55:00 | SPY | ETF | 130.54 | 131.26 | 130.525 | 131.11 | 10334759.0 |
| 2008-03-07 10:00:00 | SPY | ETF | 131.1 | 131.25 | 130.78 | 131.0 | 5145161.0 |
| 2008-03-07 10:05:00 | SPY | ETF | 131.0 | 131.08 | 130.65 | 130.75 | 7108172.0 |
| 2008-03-07 10:10:00 | SPY | ETF | 130.75 | 130.77 | 130.53 | 130.718 | 5139102.0 |
> showing 50 of 23,802 rows — these rows as CSV