PREVIEW / etf_5min / 2009-12-04
file: by_date/etf_5min/2009/2009-12-04.parquet size: 794 KB rows: 32,377
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 |
|---|---|---|---|---|---|---|---|
| 2009-12-04 04:45:00 | SPY | ETF | 110.44 | 110.44 | 110.44 | 110.44 | 1500.0 |
| 2009-12-04 04:50:00 | SPY | ETF | 110.5 | 110.5 | 110.5 | 110.5 | 234.0 |
| 2009-12-04 05:30:00 | SPY | ETF | 110.45 | 110.45 | 110.45 | 110.45 | 100.0 |
| 2009-12-04 06:00:00 | SPY | ETF | 110.48 | 110.48 | 110.48 | 110.48 | 1000.0 |
| 2009-12-04 06:05:00 | SPY | ETF | 110.49 | 110.49 | 110.49 | 110.49 | 1000.0 |
| 2009-12-04 06:10:00 | SPY | ETF | 110.5 | 110.5 | 110.5 | 110.5 | 500.0 |
| 2009-12-04 06:20:00 | SPY | ETF | 110.46 | 110.48 | 110.45 | 110.45 | 2700.0 |
| 2009-12-04 06:25:00 | SPY | ETF | 110.5 | 110.5 | 110.46 | 110.46 | 2100.0 |
| 2009-12-04 06:40:00 | SPY | ETF | 110.46 | 110.46 | 110.46 | 110.46 | 2050.0 |
| 2009-12-04 07:00:00 | SPY | ETF | 110.5 | 110.5 | 110.48 | 110.5 | 3868.0 |
| 2009-12-04 07:05:00 | SPY | ETF | 110.5 | 110.51 | 110.48 | 110.51 | 1800.0 |
| 2009-12-04 07:10:00 | SPY | ETF | 110.55 | 110.55 | 110.55 | 110.55 | 3350.0 |
| 2009-12-04 07:15:00 | SPY | ETF | 110.53 | 110.57 | 110.51 | 110.57 | 3434.0 |
| 2009-12-04 07:20:00 | SPY | ETF | 110.52 | 110.52 | 110.48 | 110.48 | 2971.0 |
| 2009-12-04 07:25:00 | SPY | ETF | 110.5 | 110.5 | 110.5 | 110.5 | 25500.0 |
| 2009-12-04 07:30:00 | SPY | ETF | 110.49 | 110.51 | 110.49 | 110.51 | 5015.0 |
| 2009-12-04 07:35:00 | SPY | ETF | 110.49 | 110.52 | 110.48 | 110.49 | 109570.0 |
| 2009-12-04 07:40:00 | SPY | ETF | 110.51 | 110.52 | 110.48 | 110.48 | 57401.0 |
| 2009-12-04 07:45:00 | SPY | ETF | 110.48 | 110.51 | 110.48 | 110.5 | 7560.0 |
| 2009-12-04 07:50:00 | SPY | ETF | 110.5 | 110.51 | 110.48 | 110.5 | 10103.0 |
| 2009-12-04 07:55:00 | SPY | ETF | 110.5 | 110.51 | 110.47 | 110.47 | 24793.0 |
| 2009-12-04 08:00:00 | SPY | ETF | 110.47 | 110.47 | 109.83 | 110.44 | 117010.0 |
| 2009-12-04 08:05:00 | SPY | ETF | 110.44 | 110.47 | 110.43 | 110.46 | 64073.0 |
| 2009-12-04 08:10:00 | SPY | ETF | 110.46 | 110.49 | 110.44 | 110.49 | 60797.0 |
| 2009-12-04 08:15:00 | SPY | ETF | 110.5 | 110.51 | 110.47 | 110.49 | 176702.0 |
| 2009-12-04 08:20:00 | SPY | ETF | 110.5 | 110.5 | 110.38 | 110.45 | 268728.0 |
| 2009-12-04 08:25:00 | SPY | ETF | 110.44 | 111.14 | 110.38 | 110.67 | 500728.0 |
| 2009-12-04 08:30:00 | SPY | ETF | 110.64 | 111.78 | 110.64 | 111.66 | 9228938.0 |
| 2009-12-04 08:35:00 | SPY | ETF | 111.66 | 111.88 | 111.66 | 111.77 | 3122372.0 |
| 2009-12-04 08:40:00 | SPY | ETF | 111.77 | 111.81 | 111.5 | 111.55 | 2656541.0 |
| 2009-12-04 08:45:00 | SPY | ETF | 111.55 | 111.64 | 111.5 | 111.57 | 893612.0 |
| 2009-12-04 08:50:00 | SPY | ETF | 111.56 | 111.73 | 110.28 | 111.72 | 771676.0 |
| 2009-12-04 08:55:00 | SPY | ETF | 111.72 | 111.72 | 111.46 | 111.59 | 857597.0 |
| 2009-12-04 09:00:00 | SPY | ETF | 111.59 | 111.65 | 111.41 | 111.51 | 1184482.0 |
| 2009-12-04 09:05:00 | SPY | ETF | 111.52 | 111.82 | 111.47 | 111.64 | 712766.0 |
| 2009-12-04 09:10:00 | SPY | ETF | 111.64 | 111.88 | 111.6 | 111.85 | 867396.0 |
| 2009-12-04 09:15:00 | SPY | ETF | 111.85 | 111.92 | 111.78 | 111.79 | 517493.0 |
| 2009-12-04 09:20:00 | SPY | ETF | 111.78 | 111.86 | 111.71 | 111.74 | 351201.0 |
| 2009-12-04 09:25:00 | SPY | ETF | 111.74 | 111.85 | 111.71 | 111.85 | 648277.0 |
| 2009-12-04 09:30:00 | SPY | ETF | 111.84 | 111.92 | 111.66 | 111.67 | 4826295.0 |
| 2009-12-04 09:35:00 | SPY | ETF | 111.6699 | 112.13 | 111.65 | 112.0583 | 6984220.0 |
| 2009-12-04 09:40:00 | SPY | ETF | 112.05 | 112.34 | 112.03 | 112.15 | 8520394.0 |
| 2009-12-04 09:45:00 | SPY | ETF | 112.15 | 112.38 | 112.12 | 112.34 | 4167761.0 |
| 2009-12-04 09:50:00 | SPY | ETF | 112.34 | 112.36 | 112.14 | 112.16 | 3185603.0 |
| 2009-12-04 09:55:00 | SPY | ETF | 112.17 | 112.23 | 112.1 | 112.17 | 2532523.0 |
| 2009-12-04 10:00:00 | SPY | ETF | 112.17 | 112.24 | 111.96 | 111.96 | 4276189.0 |
| 2009-12-04 10:05:00 | SPY | ETF | 111.96 | 112.07 | 111.8 | 112.03 | 5169011.0 |
| 2009-12-04 10:10:00 | SPY | ETF | 112.03 | 112.03 | 111.8 | 111.96 | 4085310.0 |
| 2009-12-04 10:15:00 | SPY | ETF | 111.96 | 112.06 | 111.89 | 111.92 | 3953481.0 |
| 2009-12-04 10:20:00 | SPY | ETF | 111.91 | 111.97 | 111.83 | 111.891 | 1730965.0 |
> showing 50 of 32,377 rows — these rows as CSV