PREVIEW / etf_5min / 2010-05-14
file: by_date/etf_5min/2010/2010-05-14.parquet size: 889 KB rows: 35,826
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-05-14 04:15:00 | SPY | ETF | 115.75 | 115.75 | 115.75 | 115.75 | 140.0 |
| 2010-05-14 04:25:00 | SPY | ETF | 115.5 | 115.5 | 115.48 | 115.48 | 400.0 |
| 2010-05-14 04:55:00 | SPY | ETF | 115.44 | 115.44 | 115.44 | 115.44 | 100.0 |
| 2010-05-14 05:00:00 | SPY | ETF | 115.47 | 115.47 | 115.45 | 115.45 | 1200.0 |
| 2010-05-14 05:05:00 | SPY | ETF | 115.35 | 115.37 | 115.35 | 115.37 | 15000.0 |
| 2010-05-14 05:10:00 | SPY | ETF | 115.45 | 115.45 | 115.45 | 115.45 | 500.0 |
| 2010-05-14 05:15:00 | SPY | ETF | 115.21 | 115.21 | 115.21 | 115.21 | 800.0 |
| 2010-05-14 05:20:00 | SPY | ETF | 115.3 | 115.3 | 115.3 | 115.3 | 1000.0 |
| 2010-05-14 05:25:00 | SPY | ETF | 115.33 | 115.4 | 115.33 | 115.4 | 11100.0 |
| 2010-05-14 05:40:00 | SPY | ETF | 115.23 | 115.23 | 115.23 | 115.23 | 2000.0 |
| 2010-05-14 05:45:00 | SPY | ETF | 115.18 | 115.18 | 115.13 | 115.13 | 670.0 |
| 2010-05-14 05:50:00 | SPY | ETF | 115.1 | 115.1 | 115.08 | 115.08 | 200.0 |
| 2010-05-14 06:00:00 | SPY | ETF | 115.2 | 115.2 | 115.2 | 115.2 | 600.0 |
| 2010-05-14 06:05:00 | SPY | ETF | 115.2 | 115.2 | 115.1 | 115.1 | 20600.0 |
| 2010-05-14 06:15:00 | SPY | ETF | 115.27 | 115.35 | 115.27 | 115.31 | 832.0 |
| 2010-05-14 06:25:00 | SPY | ETF | 115.34 | 115.35 | 115.34 | 115.35 | 1200.0 |
| 2010-05-14 06:30:00 | SPY | ETF | 115.25 | 115.33 | 115.25 | 115.33 | 620.0 |
| 2010-05-14 06:35:00 | SPY | ETF | 115.34 | 115.34 | 115.25 | 115.25 | 5400.0 |
| 2010-05-14 06:40:00 | SPY | ETF | 115.35 | 115.35 | 115.35 | 115.35 | 200.0 |
| 2010-05-14 06:45:00 | SPY | ETF | 115.34 | 115.34 | 115.2 | 115.2 | 3700.0 |
| 2010-05-14 06:50:00 | SPY | ETF | 115.2 | 115.32 | 115.16 | 115.32 | 12800.0 |
| 2010-05-14 06:55:00 | SPY | ETF | 115.38 | 115.4 | 115.38 | 115.38 | 800.0 |
| 2010-05-14 07:00:00 | SPY | ETF | 115.42 | 115.47 | 115.4 | 115.47 | 15492.0 |
| 2010-05-14 07:05:00 | SPY | ETF | 115.44 | 115.52 | 115.44 | 115.51 | 39760.0 |
| 2010-05-14 07:10:00 | SPY | ETF | 115.48 | 115.48 | 115.4 | 115.47 | 100300.0 |
| 2010-05-14 07:15:00 | SPY | ETF | 115.46 | 115.46 | 115.31 | 115.33 | 65125.0 |
| 2010-05-14 07:20:00 | SPY | ETF | 115.33 | 115.54 | 115.33 | 115.44 | 55500.0 |
| 2010-05-14 07:25:00 | SPY | ETF | 115.43 | 115.49 | 115.33 | 115.39 | 229150.0 |
| 2010-05-14 07:30:00 | SPY | ETF | 115.41 | 115.44 | 115.36 | 115.44 | 134950.0 |
| 2010-05-14 07:35:00 | SPY | ETF | 115.43 | 115.49 | 115.38 | 115.47 | 43088.0 |
| 2010-05-14 07:40:00 | SPY | ETF | 115.47 | 115.49 | 115.44 | 115.49 | 10900.0 |
| 2010-05-14 07:45:00 | SPY | ETF | 115.5 | 115.53 | 115.45 | 115.46 | 141665.0 |
| 2010-05-14 07:50:00 | SPY | ETF | 115.48 | 115.49 | 115.25 | 115.32 | 73425.0 |
| 2010-05-14 07:55:00 | SPY | ETF | 115.31 | 115.37 | 115.25 | 115.27 | 78291.0 |
| 2010-05-14 08:00:00 | SPY | ETF | 115.26 | 115.32 | 115.23 | 115.24 | 130220.0 |
| 2010-05-14 08:05:00 | SPY | ETF | 115.23 | 115.34 | 115.16 | 115.16 | 263207.0 |
| 2010-05-14 08:10:00 | SPY | ETF | 115.15 | 115.17 | 114.99 | 115.09 | 1007194.0 |
| 2010-05-14 08:15:00 | SPY | ETF | 115.1 | 115.14 | 115.06 | 115.12 | 508303.0 |
| 2010-05-14 08:20:00 | SPY | ETF | 115.12 | 115.19 | 115.08 | 115.15 | 896666.0 |
| 2010-05-14 08:25:00 | SPY | ETF | 115.15 | 115.19 | 115.08 | 115.15 | 669967.0 |
| 2010-05-14 08:30:00 | SPY | ETF | 115.16 | 115.4 | 114.91 | 115.06 | 1446635.0 |
| 2010-05-14 08:35:00 | SPY | ETF | 115.07 | 115.25 | 115.05 | 115.25 | 356186.0 |
| 2010-05-14 08:40:00 | SPY | ETF | 115.25 | 115.4 | 115.21 | 115.36 | 275045.0 |
| 2010-05-14 08:45:00 | SPY | ETF | 115.36 | 115.47 | 115.3 | 115.45 | 388146.0 |
| 2010-05-14 08:50:00 | SPY | ETF | 115.44 | 115.48 | 115.35 | 115.46 | 397335.0 |
| 2010-05-14 08:55:00 | SPY | ETF | 115.44 | 115.46 | 115.22 | 115.25 | 449513.0 |
| 2010-05-14 09:00:00 | SPY | ETF | 115.24 | 115.25 | 115.05 | 115.07 | 334980.0 |
| 2010-05-14 09:05:00 | SPY | ETF | 115.06 | 115.26 | 115.06 | 115.09 | 607487.0 |
| 2010-05-14 09:10:00 | SPY | ETF | 115.1 | 115.1 | 114.88 | 115.01 | 594803.0 |
| 2010-05-14 09:15:00 | SPY | ETF | 115.01 | 115.04 | 114.91 | 114.97 | 314445.0 |
> showing 50 of 35,826 rows — these rows as CSV