PREVIEW / etf_30min / 2004-03-01
file: by_date/etf_30min/2004/2004-03-01.parquet size: 36 KB rows: 1,210
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 |
|---|---|---|---|---|---|---|---|
| 2004-03-01 08:00:00 | SPY | ETF | 115.4 | 115.44 | 115.37 | 115.42 | 12300.0 |
| 2004-03-01 08:30:00 | SPY | ETF | 115.41 | 115.45 | 115.36 | 115.44 | 18700.0 |
| 2004-03-01 09:00:00 | SPY | ETF | 115.43 | 115.49 | 115.41 | 115.43 | 23300.0 |
| 2004-03-01 09:30:00 | SPY | ETF | 115.41 | 115.69 | 115.38 | 115.54 | 3214200.0 |
| 2004-03-01 10:00:00 | SPY | ETF | 115.54 | 115.83 | 115.43 | 115.53 | 3830000.0 |
| 2004-03-01 10:30:00 | SPY | ETF | 115.53 | 115.65 | 115.41 | 115.43 | 3162600.0 |
| 2004-03-01 11:00:00 | SPY | ETF | 115.42 | 115.52 | 115.25 | 115.5 | 1267900.0 |
| 2004-03-01 11:30:00 | SPY | ETF | 115.51 | 115.66 | 115.43 | 115.66 | 695300.0 |
| 2004-03-01 12:00:00 | SPY | ETF | 115.66 | 115.92 | 115.64 | 115.77 | 1263500.0 |
| 2004-03-01 12:30:00 | SPY | ETF | 115.79 | 115.85 | 115.72 | 115.78 | 717200.0 |
| 2004-03-01 13:00:00 | SPY | ETF | 115.78 | 115.88 | 115.68 | 115.88 | 1084500.0 |
| 2004-03-01 13:30:00 | SPY | ETF | 115.87 | 115.95 | 115.68 | 115.89 | 1014600.0 |
| 2004-03-01 14:00:00 | SPY | ETF | 115.89 | 116.13 | 115.88 | 116.02 | 1970400.0 |
| 2004-03-01 14:30:00 | SPY | ETF | 116.02 | 116.34 | 116.0 | 116.23 | 1576400.0 |
| 2004-03-01 15:00:00 | SPY | ETF | 116.25 | 116.26 | 116.08 | 116.16 | 1223900.0 |
| 2004-03-01 15:30:00 | SPY | ETF | 116.16 | 116.21 | 116.08 | 116.11 | 2050100.0 |
| 2004-03-01 16:00:00 | SPY | ETF | 116.12 | 116.19 | 116.08 | 116.17 | 1569100.0 |
| 2004-03-01 16:30:00 | SPY | ETF | 116.17 | 116.26 | 116.13 | 116.2 | 190600.0 |
| 2004-03-01 17:00:00 | SPY | ETF | 116.23 | 116.23 | 115.7341 | 115.7341 | 63100.0 |
| 2004-03-01 17:30:00 | SPY | ETF | 116.24 | 116.24 | 116.24 | 116.24 | 1400.0 |
| 2004-03-01 18:00:00 | SPY | ETF | 116.19 | 116.19 | 116.15 | 116.15 | 4600.0 |
| 2004-03-01 18:30:00 | SPY | ETF | 116.22 | 116.22 | 116.22 | 116.22 | 2800.0 |
| 2004-03-01 19:00:00 | SPY | ETF | 116.22 | 116.22 | 116.22 | 116.22 | 200.0 |
| 2004-03-01 19:30:00 | SPY | ETF | 116.24 | 116.24 | 116.22 | 116.22 | 400.0 |
| 2004-03-01 08:00:00 | QQQ | ETF | 36.67 | 36.67 | 36.62 | 36.64 | 104100.0 |
| 2004-03-01 08:30:00 | QQQ | ETF | 36.64 | 36.67 | 36.63 | 36.65 | 104400.0 |
| 2004-03-01 09:00:00 | QQQ | ETF | 36.66 | 36.69 | 36.64 | 36.68 | 113400.0 |
| 2004-03-01 09:30:00 | QQQ | ETF | 36.69 | 36.74 | 36.58 | 36.69 | 5256200.0 |
| 2004-03-01 10:00:00 | QQQ | ETF | 36.67 | 36.83 | 36.63 | 36.7 | 7686700.0 |
| 2004-03-01 10:30:00 | QQQ | ETF | 36.7 | 36.74 | 36.589 | 36.61 | 4762800.0 |
| 2004-03-01 11:00:00 | QQQ | ETF | 36.63 | 36.63 | 36.47 | 36.58 | 4578200.0 |
| 2004-03-01 11:30:00 | QQQ | ETF | 36.59 | 36.64 | 36.51 | 36.64 | 1948100.0 |
| 2004-03-01 12:00:00 | QQQ | ETF | 36.65 | 36.76 | 36.62 | 36.68 | 4555400.0 |
| 2004-03-01 12:30:00 | QQQ | ETF | 36.68 | 36.72 | 36.64 | 36.7 | 1694300.0 |
| 2004-03-01 13:00:00 | QQQ | ETF | 36.71 | 36.75 | 36.66 | 36.748 | 2276700.0 |
| 2004-03-01 13:30:00 | QQQ | ETF | 36.74 | 36.8 | 36.68 | 36.76 | 3619700.0 |
| 2004-03-01 14:00:00 | QQQ | ETF | 36.77 | 36.89 | 36.75 | 36.83 | 7004800.0 |
| 2004-03-01 14:30:00 | QQQ | ETF | 36.83 | 37.0 | 36.82 | 36.95 | 7230700.0 |
| 2004-03-01 15:00:00 | QQQ | ETF | 36.95 | 37.06 | 36.92 | 37.02 | 7221900.0 |
| 2004-03-01 15:30:00 | QQQ | ETF | 37.03 | 37.07 | 36.96 | 36.98 | 7046100.0 |
| 2004-03-01 16:00:00 | QQQ | ETF | 36.98 | 37.08 | 36.98 | 37.04 | 2923100.0 |
| 2004-03-01 16:30:00 | QQQ | ETF | 37.05 | 37.07 | 37.02 | 37.06 | 51900.0 |
| 2004-03-01 17:00:00 | QQQ | ETF | 37.05 | 37.05 | 37.02 | 37.02 | 14000.0 |
| 2004-03-01 17:30:00 | QQQ | ETF | 37.02 | 37.07 | 37.02 | 37.06 | 46400.0 |
| 2004-03-01 18:00:00 | QQQ | ETF | 37.06 | 37.08 | 37.05 | 37.08 | 32200.0 |
| 2004-03-01 18:30:00 | QQQ | ETF | 37.05 | 37.06 | 37.05 | 37.06 | 1200.0 |
| 2004-03-01 19:00:00 | QQQ | ETF | 37.05 | 37.08 | 37.05 | 37.08 | 3900.0 |
| 2004-03-01 19:30:00 | QQQ | ETF | 37.06 | 37.09 | 37.05 | 37.05 | 4600.0 |
| 2004-03-01 09:30:00 | IWM | ETF | 58.535 | 58.655 | 58.405 | 58.575 | 691000.0 |
| 2004-03-01 10:00:00 | IWM | ETF | 58.545 | 58.855 | 58.495 | 58.78 | 1489200.0 |
> showing 50 of 1,210 rows — these rows as CSV