PREVIEW / etf_30min / 2001-04-05
file: by_date/etf_30min/2001/2001-04-05.parquet size: 14 KB rows: 341
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 |
|---|---|---|---|---|---|---|---|
| 2001-04-05 09:30:00 | SPY | ETF | 113.3 | 113.31 | 112.5 | 113.01 | 3334900.0 |
| 2001-04-05 10:00:00 | SPY | ETF | 113.06 | 113.93 | 112.95 | 113.32 | 1619700.0 |
| 2001-04-05 10:30:00 | SPY | ETF | 113.33 | 113.74 | 113.16 | 113.58 | 953900.0 |
| 2001-04-05 11:00:00 | SPY | ETF | 113.74 | 113.78 | 113.18 | 113.42 | 634900.0 |
| 2001-04-05 11:30:00 | SPY | ETF | 113.3 | 113.5 | 113.11 | 113.4 | 526100.0 |
| 2001-04-05 12:00:00 | SPY | ETF | 113.49 | 113.72 | 113.21 | 113.6 | 509600.0 |
| 2001-04-05 12:30:00 | SPY | ETF | 113.59 | 114.1 | 113.37 | 113.81 | 589200.0 |
| 2001-04-05 13:00:00 | SPY | ETF | 113.89 | 114.3 | 113.82 | 114.28 | 963200.0 |
| 2001-04-05 13:30:00 | SPY | ETF | 114.22 | 114.32 | 113.8 | 113.98 | 833000.0 |
| 2001-04-05 14:00:00 | SPY | ETF | 114.0 | 114.79 | 113.86 | 114.63 | 796800.0 |
| 2001-04-05 14:30:00 | SPY | ETF | 114.62 | 115.29 | 114.51 | 115.01 | 1308700.0 |
| 2001-04-05 15:00:00 | SPY | ETF | 115.04 | 115.44 | 114.97 | 115.1 | 802300.0 |
| 2001-04-05 15:30:00 | SPY | ETF | 115.18 | 115.49 | 114.9 | 115.22 | 1284200.0 |
| 2001-04-05 16:00:00 | SPY | ETF | 115.22 | 115.39 | 113.95 | 113.95 | 5616300.0 |
| 2001-04-05 16:30:00 | SPY | ETF | 114.21 | 115.05 | 114.21 | 115.05 | 1701000.0 |
| 2001-04-05 17:00:00 | SPY | ETF | 115.0 | 115.25 | 115.0 | 115.25 | 2400.0 |
| 2001-04-05 17:30:00 | SPY | ETF | 115.15 | 115.16 | 115.15 | 115.16 | 2500.0 |
| 2001-04-05 18:00:00 | SPY | ETF | 115.01 | 115.31 | 115.0 | 115.31 | 12900.0 |
| 2001-04-05 09:30:00 | QQQ | ETF | 36.0 | 36.28 | 35.71 | 35.93 | 15561300.0 |
| 2001-04-05 10:00:00 | QQQ | ETF | 35.91 | 36.7 | 35.86 | 36.29 | 10801900.0 |
| 2001-04-05 10:30:00 | QQQ | ETF | 36.25 | 36.6 | 36.15 | 36.56 | 4512800.0 |
| 2001-04-05 11:00:00 | QQQ | ETF | 36.59 | 36.76 | 36.27 | 36.39 | 5028600.0 |
| 2001-04-05 11:30:00 | QQQ | ETF | 36.44 | 36.52 | 36.2 | 36.47 | 3500600.0 |
| 2001-04-05 12:00:00 | QQQ | ETF | 36.47 | 36.75 | 36.37 | 36.62 | 3459500.0 |
| 2001-04-05 12:30:00 | QQQ | ETF | 36.62 | 36.91 | 36.45 | 36.89 | 3838500.0 |
| 2001-04-05 13:00:00 | QQQ | ETF | 36.87 | 37.1 | 36.65 | 37.1 | 3749800.0 |
| 2001-04-05 13:30:00 | QQQ | ETF | 37.08 | 37.16 | 36.84 | 36.99 | 4834400.0 |
| 2001-04-05 14:00:00 | QQQ | ETF | 36.99 | 37.45 | 36.84 | 37.28 | 5045500.0 |
| 2001-04-05 14:30:00 | QQQ | ETF | 37.35 | 37.8 | 37.27 | 37.64 | 6449300.0 |
| 2001-04-05 15:00:00 | QQQ | ETF | 37.62 | 37.96 | 37.58 | 37.7 | 6943200.0 |
| 2001-04-05 15:30:00 | QQQ | ETF | 37.7 | 37.95 | 37.54 | 37.77 | 8582900.0 |
| 2001-04-05 16:00:00 | QQQ | ETF | 37.77 | 37.95 | 37.3 | 37.55 | 2626200.0 |
| 2001-04-05 16:30:00 | QQQ | ETF | 37.5 | 37.87 | 37.0 | 37.51 | 1481500.0 |
| 2001-04-05 17:00:00 | QQQ | ETF | 37.59 | 37.7 | 37.46 | 37.54 | 47900.0 |
| 2001-04-05 17:30:00 | QQQ | ETF | 37.56 | 37.75 | 37.51 | 37.64 | 45700.0 |
| 2001-04-05 18:00:00 | QQQ | ETF | 37.75 | 37.9 | 37.65 | 37.9 | 73300.0 |
| 2001-04-05 09:30:00 | IWM | ETF | 43.0 | 43.425 | 43.0 | 43.425 | 280800.0 |
| 2001-04-05 10:00:00 | IWM | ETF | 43.5 | 43.7 | 43.5 | 43.65 | 67000.0 |
| 2001-04-05 10:30:00 | IWM | ETF | 43.55 | 43.55 | 43.53 | 43.55 | 60200.0 |
| 2001-04-05 11:00:00 | IWM | ETF | 43.55 | 43.72 | 43.5 | 43.5 | 77400.0 |
| 2001-04-05 11:30:00 | IWM | ETF | 43.525 | 43.575 | 43.525 | 43.575 | 10800.0 |
| 2001-04-05 12:00:00 | IWM | ETF | 43.595 | 43.62 | 43.525 | 43.62 | 20800.0 |
| 2001-04-05 12:30:00 | IWM | ETF | 43.675 | 43.7 | 43.555 | 43.7 | 28200.0 |
| 2001-04-05 13:00:00 | IWM | ETF | 43.75 | 43.8 | 43.65 | 43.65 | 71400.0 |
| 2001-04-05 13:30:00 | IWM | ETF | 43.8 | 43.825 | 43.565 | 43.675 | 82600.0 |
| 2001-04-05 14:00:00 | IWM | ETF | 43.675 | 43.895 | 43.675 | 43.895 | 54800.0 |
| 2001-04-05 14:30:00 | IWM | ETF | 43.875 | 44.05 | 43.875 | 44.0 | 60200.0 |
| 2001-04-05 15:00:00 | IWM | ETF | 44.125 | 44.15 | 44.125 | 44.15 | 11400.0 |
| 2001-04-05 15:30:00 | IWM | ETF | 44.05 | 44.45 | 44.05 | 44.45 | 114400.0 |
| 2001-04-05 16:00:00 | IWM | ETF | 44.45 | 44.45 | 44.45 | 44.45 | 10000.0 |
> showing 50 of 341 rows — these rows as CSV