PREVIEW / etf_30min / 2005-10-03
file: by_date/etf_30min/2005/2005-10-03.parquet size: 47 KB rows: 1,739
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 |
|---|---|---|---|---|---|---|---|
| 2005-10-03 07:00:00 | SPY | ETF | 123.05 | 123.05 | 123.04 | 123.04 | 5000.0 |
| 2005-10-03 07:30:00 | SPY | ETF | 123.08 | 123.08 | 123.0 | 123.0 | 1400.0 |
| 2005-10-03 08:00:00 | SPY | ETF | 123.01 | 123.1 | 122.94 | 122.94 | 135600.0 |
| 2005-10-03 08:30:00 | SPY | ETF | 122.94 | 123.06 | 122.92 | 123.0 | 47400.0 |
| 2005-10-03 09:00:00 | SPY | ETF | 123.03 | 123.05 | 122.9 | 122.93 | 239600.0 |
| 2005-10-03 09:30:00 | SPY | ETF | 122.96 | 123.34 | 122.85 | 123.22 | 10297000.0 |
| 2005-10-03 10:00:00 | SPY | ETF | 123.22 | 123.33 | 122.68 | 122.77 | 9156200.0 |
| 2005-10-03 10:30:00 | SPY | ETF | 122.78 | 122.85 | 122.49 | 122.53 | 3543900.0 |
| 2005-10-03 11:00:00 | SPY | ETF | 122.51 | 122.8 | 122.51 | 122.75 | 2471400.0 |
| 2005-10-03 11:30:00 | SPY | ETF | 122.76 | 122.82 | 122.64 | 122.65 | 2191400.0 |
| 2005-10-03 12:00:00 | SPY | ETF | 122.64 | 122.74 | 122.56 | 122.61 | 1136000.0 |
| 2005-10-03 12:30:00 | SPY | ETF | 122.61 | 122.67 | 122.48 | 122.56 | 1014100.0 |
| 2005-10-03 13:00:00 | SPY | ETF | 122.55 | 122.76 | 122.54 | 122.6 | 1001700.0 |
| 2005-10-03 13:30:00 | SPY | ETF | 122.6 | 122.83 | 122.53 | 122.73 | 1889900.0 |
| 2005-10-03 14:00:00 | SPY | ETF | 122.72 | 122.76 | 122.45 | 122.68 | 2143600.0 |
| 2005-10-03 14:30:00 | SPY | ETF | 122.67 | 122.88 | 122.6 | 122.78 | 2636800.0 |
| 2005-10-03 15:00:00 | SPY | ETF | 122.79 | 122.92 | 122.69 | 122.74 | 2666200.0 |
| 2005-10-03 15:30:00 | SPY | ETF | 122.75 | 122.88 | 122.59 | 122.68 | 4144700.0 |
| 2005-10-03 16:00:00 | SPY | ETF | 122.66 | 122.67 | 122.54 | 122.55 | 2689600.0 |
| 2005-10-03 16:30:00 | SPY | ETF | 122.58 | 122.58 | 122.55 | 122.56 | 148800.0 |
| 2005-10-03 17:00:00 | SPY | ETF | 122.53 | 122.55 | 122.52 | 122.55 | 15700.0 |
| 2005-10-03 17:30:00 | SPY | ETF | 122.55 | 122.59 | 122.52 | 122.52 | 2500.0 |
| 2005-10-03 18:00:00 | SPY | ETF | 122.57 | 122.59 | 122.57 | 122.57 | 20300.0 |
| 2005-10-03 18:30:00 | SPY | ETF | 122.59 | 122.63 | 122.59 | 122.63 | 1200.0 |
| 2005-10-03 19:30:00 | SPY | ETF | 122.63 | 122.63 | 122.63 | 122.63 | 1000.0 |
| 2005-10-03 09:30:00 | QQQ | ETF | 39.54 | 39.75 | 39.53 | 39.69 | 13886000.0 |
| 2005-10-03 10:00:00 | QQQ | ETF | 39.69 | 39.73 | 39.51 | 39.6 | 7360100.0 |
| 2005-10-03 10:30:00 | QQQ | ETF | 39.6 | 39.63 | 39.54 | 39.57 | 5549200.0 |
| 2005-10-03 11:00:00 | QQQ | ETF | 39.56 | 39.66 | 39.56 | 39.65 | 3371200.0 |
| 2005-10-03 11:30:00 | QQQ | ETF | 39.65 | 39.68 | 39.61 | 39.63 | 2609700.0 |
| 2005-10-03 12:00:00 | QQQ | ETF | 39.64 | 39.66 | 39.55 | 39.58 | 2562200.0 |
| 2005-10-03 12:30:00 | QQQ | ETF | 39.58 | 39.61 | 39.53 | 39.59 | 1858300.0 |
| 2005-10-03 13:00:00 | QQQ | ETF | 39.59 | 39.68 | 39.59 | 39.61 | 5006900.0 |
| 2005-10-03 13:30:00 | QQQ | ETF | 39.61 | 39.68 | 39.58 | 39.64 | 2170900.0 |
| 2005-10-03 14:00:00 | QQQ | ETF | 39.64 | 39.67 | 39.53 | 39.62 | 3717400.0 |
| 2005-10-03 14:30:00 | QQQ | ETF | 39.62 | 39.73 | 39.58 | 39.67 | 8682200.0 |
| 2005-10-03 15:00:00 | QQQ | ETF | 39.67 | 39.71 | 39.58 | 39.6 | 3369200.0 |
| 2005-10-03 15:30:00 | QQQ | ETF | 39.61 | 39.66 | 39.56 | 39.57 | 9024500.0 |
| 2005-10-03 08:00:00 | IWM | ETF | 66.39 | 66.4 | 66.38 | 66.4 | 6300.0 |
| 2005-10-03 08:30:00 | IWM | ETF | 66.42 | 66.47 | 66.39 | 66.39 | 49000.0 |
| 2005-10-03 09:00:00 | IWM | ETF | 66.39 | 66.45 | 66.39 | 66.42 | 193300.0 |
| 2005-10-03 09:30:00 | IWM | ETF | 66.49 | 66.99 | 66.44 | 66.99 | 5674800.0 |
| 2005-10-03 10:00:00 | IWM | ETF | 66.98 | 67.06 | 66.58 | 66.66 | 7626100.0 |
| 2005-10-03 10:30:00 | IWM | ETF | 66.65 | 66.66 | 66.48 | 66.49 | 1592600.0 |
| 2005-10-03 11:00:00 | IWM | ETF | 66.49 | 66.8 | 66.49 | 66.78 | 1312300.0 |
| 2005-10-03 11:30:00 | IWM | ETF | 66.78 | 66.78 | 66.59 | 66.63 | 468400.0 |
| 2005-10-03 12:00:00 | IWM | ETF | 66.61 | 66.72 | 66.55 | 66.59 | 1468200.0 |
| 2005-10-03 12:30:00 | IWM | ETF | 66.59 | 66.61 | 66.48 | 66.5 | 766900.0 |
| 2005-10-03 13:00:00 | IWM | ETF | 66.5 | 66.73 | 66.49 | 66.61 | 375200.0 |
| 2005-10-03 13:30:00 | IWM | ETF | 66.61 | 66.72 | 66.58 | 66.65 | 353900.0 |
> showing 50 of 1,739 rows — these rows as CSV