PREVIEW / etf_30min / 2008-03-11
file: by_date/etf_30min/2008/2008-03-11.parquet size: 169 KB rows: 6,038
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 |
|---|---|---|---|---|---|---|---|
| 2008-03-11 04:00:00 | SPY | ETF | 128.36 | 128.36 | 128.36 | 128.36 | 200.0 |
| 2008-03-11 04:30:00 | SPY | ETF | 128.22 | 128.22 | 128.22 | 128.22 | 2500.0 |
| 2008-03-11 05:00:00 | SPY | ETF | 128.58 | 128.73 | 128.58 | 128.73 | 400.0 |
| 2008-03-11 05:30:00 | SPY | ETF | 128.76 | 128.76 | 128.76 | 128.76 | 500.0 |
| 2008-03-11 06:00:00 | SPY | ETF | 128.9 | 128.9 | 128.69 | 128.69 | 26100.0 |
| 2008-03-11 06:30:00 | SPY | ETF | 128.66 | 128.85 | 128.66 | 128.85 | 15800.0 |
| 2008-03-11 07:00:00 | SPY | ETF | 128.84 | 129.0 | 128.7 | 128.7 | 474600.0 |
| 2008-03-11 07:30:00 | SPY | ETF | 128.72 | 128.94 | 128.6 | 128.65 | 797000.0 |
| 2008-03-11 08:00:00 | SPY | ETF | 128.65 | 129.0 | 128.3 | 128.62 | 4018700.0 |
| 2008-03-11 08:30:00 | SPY | ETF | 128.64 | 131.26 | 128.63 | 130.84 | 26417711.0 |
| 2008-03-11 09:00:00 | SPY | ETF | 130.84 | 131.04 | 128.35 | 130.71 | 6971200.0 |
| 2008-03-11 09:30:00 | SPY | ETF | 130.72 | 130.96 | 130.11 | 130.16 | 32809494.0 |
| 2008-03-11 10:00:00 | SPY | ETF | 130.15 | 130.53 | 129.94 | 130.33 | 19919233.0 |
| 2008-03-11 10:30:00 | SPY | ETF | 130.33 | 130.48 | 129.9 | 130.3 | 13613149.0 |
| 2008-03-11 11:00:00 | SPY | ETF | 130.3 | 130.5 | 129.65 | 130.04 | 18628021.0 |
| 2008-03-11 11:30:00 | SPY | ETF | 130.03 | 130.14 | 129.0 | 129.22 | 22923320.0 |
| 2008-03-11 12:00:00 | SPY | ETF | 129.22 | 129.77 | 129.2 | 129.54 | 17225076.0 |
| 2008-03-11 12:30:00 | SPY | ETF | 129.53 | 129.7 | 128.95 | 129.56 | 17792490.0 |
| 2008-03-11 13:00:00 | SPY | ETF | 129.55 | 130.2 | 129.28 | 130.131 | 19949483.0 |
| 2008-03-11 13:30:00 | SPY | ETF | 130.13 | 130.37 | 129.73 | 130.3 | 15509936.0 |
| 2008-03-11 14:00:00 | SPY | ETF | 130.29 | 130.75 | 130.2 | 130.45 | 13026332.0 |
| 2008-03-11 14:30:00 | SPY | ETF | 130.45 | 131.53 | 130.37 | 131.28 | 39030953.0 |
| 2008-03-11 15:00:00 | SPY | ETF | 131.27 | 131.86 | 131.07 | 131.81 | 21209776.0 |
| 2008-03-11 15:30:00 | SPY | ETF | 131.82 | 132.46 | 131.4 | 132.39 | 33102383.0 |
| 2008-03-11 16:00:00 | SPY | ETF | 132.351 | 132.75 | 131.38 | 132.71 | 9653200.0 |
| 2008-03-11 16:30:00 | SPY | ETF | 132.71 | 132.77 | 132.61 | 132.75 | 2086720.0 |
| 2008-03-11 17:00:00 | SPY | ETF | 132.76 | 132.98 | 130.59 | 132.95 | 2270700.0 |
| 2008-03-11 17:30:00 | SPY | ETF | 132.98 | 133.07 | 132.9 | 133.06 | 180100.0 |
| 2008-03-11 18:00:00 | SPY | ETF | 133.05 | 133.15 | 132.95 | 132.95 | 188800.0 |
| 2008-03-11 18:30:00 | SPY | ETF | 132.95 | 133.01 | 132.9 | 132.91 | 22900.0 |
| 2008-03-11 19:00:00 | SPY | ETF | 132.94 | 133.0 | 132.94 | 132.95 | 22300.0 |
| 2008-03-11 19:30:00 | SPY | ETF | 132.94 | 132.94 | 132.75 | 132.85 | 27800.0 |
| 2008-03-11 04:00:00 | QQQ | ETF | 41.35 | 41.37 | 41.34 | 41.37 | 2700.0 |
| 2008-03-11 05:00:00 | QQQ | ETF | 41.34 | 41.41 | 41.33 | 41.41 | 1900.0 |
| 2008-03-11 05:30:00 | QQQ | ETF | 41.41 | 41.43 | 41.4 | 41.4 | 22400.0 |
| 2008-03-11 06:00:00 | QQQ | ETF | 41.41 | 41.46 | 41.41 | 41.42 | 4000.0 |
| 2008-03-11 06:30:00 | QQQ | ETF | 41.38 | 41.43 | 41.37 | 41.43 | 21200.0 |
| 2008-03-11 07:00:00 | QQQ | ETF | 41.41 | 41.47 | 41.35 | 41.36 | 420484.0 |
| 2008-03-11 07:30:00 | QQQ | ETF | 41.38 | 41.43 | 41.29 | 41.3 | 513265.0 |
| 2008-03-11 08:00:00 | QQQ | ETF | 41.3 | 41.37 | 41.18 | 41.31 | 2346896.0 |
| 2008-03-11 08:30:00 | QQQ | ETF | 41.32 | 42.09 | 41.32 | 41.97 | 9736559.0 |
| 2008-03-11 09:00:00 | QQQ | ETF | 41.97 | 42.02 | 41.85 | 41.86 | 3238184.0 |
| 2008-03-11 09:30:00 | QQQ | ETF | 41.86 | 42.19 | 41.85 | 41.88 | 27885603.0 |
| 2008-03-11 10:00:00 | QQQ | ETF | 41.88 | 42.05 | 41.74 | 41.99 | 15367318.0 |
| 2008-03-11 10:30:00 | QQQ | ETF | 41.99 | 42.0 | 41.85 | 41.985 | 5783380.0 |
| 2008-03-11 11:00:00 | QQQ | ETF | 41.99 | 42.03 | 41.84 | 41.96 | 8559173.0 |
| 2008-03-11 11:30:00 | QQQ | ETF | 41.96 | 42.0 | 41.59 | 41.68 | 10779425.0 |
| 2008-03-11 12:00:00 | QQQ | ETF | 41.68 | 41.86 | 41.65 | 41.75 | 7348799.0 |
| 2008-03-11 12:30:00 | QQQ | ETF | 41.74 | 41.75 | 41.51 | 41.72 | 9933449.0 |
| 2008-03-11 13:00:00 | QQQ | ETF | 41.72 | 42.0 | 41.66 | 41.99 | 12710548.0 |
> showing 50 of 6,038 rows — these rows as CSV