PREVIEW / etf_30min / 2005-05-16
file: by_date/etf_30min/2005/2005-05-16.parquet size: 43 KB rows: 1,478
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-05-16 06:00:00 | SPY | ETF | 115.82 | 115.82 | 115.82 | 115.82 | 5000.0 |
| 2005-05-16 07:00:00 | SPY | ETF | 115.7 | 115.77 | 115.7 | 115.77 | 63200.0 |
| 2005-05-16 07:30:00 | SPY | ETF | 115.9 | 115.91 | 115.85 | 115.85 | 26600.0 |
| 2005-05-16 08:00:00 | SPY | ETF | 115.85 | 115.95 | 115.85 | 115.9 | 150400.0 |
| 2005-05-16 08:30:00 | SPY | ETF | 115.9 | 115.9 | 115.67 | 115.79 | 188600.0 |
| 2005-05-16 09:00:00 | SPY | ETF | 115.78 | 115.78 | 115.65 | 115.68 | 107500.0 |
| 2005-05-16 09:30:00 | SPY | ETF | 115.7 | 116.19 | 115.66 | 115.9 | 7602400.0 |
| 2005-05-16 10:00:00 | SPY | ETF | 115.9 | 116.2 | 115.86 | 116.1 | 5013900.0 |
| 2005-05-16 10:30:00 | SPY | ETF | 116.1 | 116.37 | 115.85 | 116.34 | 3842500.0 |
| 2005-05-16 11:00:00 | SPY | ETF | 116.34 | 116.35 | 116.11 | 116.18 | 3729400.0 |
| 2005-05-16 11:30:00 | SPY | ETF | 116.17 | 116.26 | 116.06 | 116.2 | 1437500.0 |
| 2005-05-16 12:00:00 | SPY | ETF | 116.2 | 116.36 | 116.14 | 116.19 | 1918200.0 |
| 2005-05-16 12:30:00 | SPY | ETF | 116.19 | 116.33 | 116.06 | 116.31 | 1431900.0 |
| 2005-05-16 13:00:00 | SPY | ETF | 116.31 | 116.39 | 116.14 | 116.33 | 1121400.0 |
| 2005-05-16 13:30:00 | SPY | ETF | 116.33 | 116.59 | 116.22 | 116.56 | 3711900.0 |
| 2005-05-16 14:00:00 | SPY | ETF | 116.53 | 116.62 | 116.34 | 116.48 | 3578200.0 |
| 2005-05-16 14:30:00 | SPY | ETF | 116.49 | 116.55 | 116.33 | 116.44 | 2409500.0 |
| 2005-05-16 15:00:00 | SPY | ETF | 116.44 | 116.83 | 116.39 | 116.78 | 5497100.0 |
| 2005-05-16 15:30:00 | SPY | ETF | 116.78 | 116.83 | 116.2784 | 116.79 | 4715800.0 |
| 2005-05-16 16:00:00 | SPY | ETF | 116.8 | 116.86 | 116.73 | 116.8 | 1340100.0 |
| 2005-05-16 16:30:00 | SPY | ETF | 116.76 | 116.8 | 116.76 | 116.8 | 142400.0 |
| 2005-05-16 17:00:00 | SPY | ETF | 116.8 | 116.82 | 116.78 | 116.78 | 7500.0 |
| 2005-05-16 17:30:00 | SPY | ETF | 116.78 | 116.8 | 116.78 | 116.78 | 400.0 |
| 2005-05-16 18:00:00 | SPY | ETF | 116.78 | 116.78 | 116.77 | 116.77 | 5200.0 |
| 2005-05-16 18:30:00 | SPY | ETF | 116.77 | 116.77 | 116.77 | 116.77 | 400.0 |
| 2005-05-16 19:30:00 | SPY | ETF | 116.75 | 116.75 | 116.75 | 116.75 | 500.0 |
| 2005-05-16 09:30:00 | QQQ | ETF | 36.24 | 36.33 | 36.13 | 36.17 | 12972900.0 |
| 2005-05-16 10:00:00 | QQQ | ETF | 36.16 | 36.31 | 36.15 | 36.28 | 7561500.0 |
| 2005-05-16 10:30:00 | QQQ | ETF | 36.28 | 36.4 | 36.21 | 36.39 | 8543700.0 |
| 2005-05-16 11:00:00 | QQQ | ETF | 36.39 | 36.39 | 36.28 | 36.28 | 4075200.0 |
| 2005-05-16 11:30:00 | QQQ | ETF | 36.29 | 36.34 | 36.27 | 36.31 | 1943300.0 |
| 2005-05-16 12:00:00 | QQQ | ETF | 36.32 | 36.37 | 36.31 | 36.34 | 2257700.0 |
| 2005-05-16 12:30:00 | QQQ | ETF | 36.35 | 36.38 | 36.31 | 36.38 | 1954700.0 |
| 2005-05-16 13:00:00 | QQQ | ETF | 36.38 | 36.38 | 36.3 | 36.35 | 2473600.0 |
| 2005-05-16 13:30:00 | QQQ | ETF | 36.35 | 36.4 | 36.32 | 36.39 | 4495600.0 |
| 2005-05-16 14:00:00 | QQQ | ETF | 36.38 | 36.41 | 36.33 | 36.36 | 5305800.0 |
| 2005-05-16 14:30:00 | QQQ | ETF | 36.36 | 36.42 | 36.33 | 36.39 | 3239400.0 |
| 2005-05-16 15:00:00 | QQQ | ETF | 36.39 | 36.54 | 36.36 | 36.51 | 11265500.0 |
| 2005-05-16 15:30:00 | QQQ | ETF | 36.5 | 36.52 | 36.47 | 36.49 | 7948800.0 |
| 2005-05-16 08:00:00 | IWM | ETF | 58.09 | 58.09 | 58.09 | 58.09 | 1000.0 |
| 2005-05-16 08:30:00 | IWM | ETF | 58.085 | 58.085 | 58.085 | 58.085 | 200.0 |
| 2005-05-16 09:00:00 | IWM | ETF | 58.03 | 58.03 | 58.0 | 58.0 | 600.0 |
| 2005-05-16 09:30:00 | IWM | ETF | 58.015 | 58.48 | 57.95 | 58.28 | 5020200.0 |
| 2005-05-16 10:00:00 | IWM | ETF | 58.275 | 58.435 | 58.235 | 58.345 | 3211800.0 |
| 2005-05-16 10:30:00 | IWM | ETF | 58.355 | 58.59 | 58.23 | 58.57 | 4058600.0 |
| 2005-05-16 11:00:00 | IWM | ETF | 58.565 | 58.575 | 58.445 | 58.47 | 2136400.0 |
| 2005-05-16 11:30:00 | IWM | ETF | 58.47 | 58.55 | 58.38 | 58.45 | 1427400.0 |
| 2005-05-16 12:00:00 | IWM | ETF | 58.45 | 58.55 | 58.44 | 58.515 | 713000.0 |
| 2005-05-16 12:30:00 | IWM | ETF | 58.515 | 58.55 | 58.41 | 58.515 | 622800.0 |
| 2005-05-16 13:00:00 | IWM | ETF | 58.515 | 58.63 | 58.415 | 58.595 | 705600.0 |
> showing 50 of 1,478 rows — these rows as CSV