PREVIEW / etf_30min / 2010-03-08
file: by_date/etf_30min/2010/2010-03-08.parquet size: 241 KB rows: 8,328
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 |
|---|---|---|---|---|---|---|---|
| 2010-03-08 04:00:00 | SPY | ETF | 114.18 | 114.18 | 114.18 | 114.18 | 100.0 |
| 2010-03-08 04:30:00 | SPY | ETF | 114.15 | 114.15 | 114.15 | 114.15 | 100.0 |
| 2010-03-08 05:30:00 | SPY | ETF | 114.02 | 114.02 | 114.02 | 114.02 | 2200.0 |
| 2010-03-08 06:00:00 | SPY | ETF | 114.04 | 114.05 | 114.02 | 114.02 | 2700.0 |
| 2010-03-08 06:30:00 | SPY | ETF | 114.07 | 114.13 | 114.07 | 114.12 | 5125.0 |
| 2010-03-08 07:00:00 | SPY | ETF | 114.11 | 114.28 | 114.1 | 114.28 | 69532.0 |
| 2010-03-08 07:30:00 | SPY | ETF | 114.28 | 114.33 | 114.22 | 114.28 | 194499.0 |
| 2010-03-08 08:00:00 | SPY | ETF | 114.27 | 114.39 | 114.18 | 114.21 | 429453.0 |
| 2010-03-08 08:30:00 | SPY | ETF | 114.21 | 114.26 | 114.12 | 114.15 | 457207.0 |
| 2010-03-08 09:00:00 | SPY | ETF | 114.16 | 114.29 | 114.16 | 114.27 | 793653.0 |
| 2010-03-08 09:30:00 | SPY | ETF | 114.26 | 114.52 | 114.2 | 114.22 | 17631145.0 |
| 2010-03-08 10:00:00 | SPY | ETF | 114.22 | 114.47 | 114.19 | 114.37 | 10149542.0 |
| 2010-03-08 10:30:00 | SPY | ETF | 114.37 | 114.43 | 114.18 | 114.39 | 12371820.0 |
| 2010-03-08 11:00:00 | SPY | ETF | 114.39 | 114.41 | 114.09 | 114.14 | 7635041.0 |
| 2010-03-08 11:30:00 | SPY | ETF | 114.14 | 114.23 | 114.07 | 114.14 | 6771730.0 |
| 2010-03-08 12:00:00 | SPY | ETF | 114.14 | 114.3 | 114.1 | 114.3 | 7128907.0 |
| 2010-03-08 12:30:00 | SPY | ETF | 114.29 | 114.33 | 114.11 | 114.33 | 5824343.0 |
| 2010-03-08 13:00:00 | SPY | ETF | 114.33 | 114.42 | 114.31 | 114.365 | 5241380.0 |
| 2010-03-08 13:30:00 | SPY | ETF | 114.365 | 114.47 | 114.35 | 114.4101 | 4876503.0 |
| 2010-03-08 14:00:00 | SPY | ETF | 114.42 | 114.47 | 114.3 | 114.38 | 4677477.0 |
| 2010-03-08 14:30:00 | SPY | ETF | 114.38 | 114.42 | 114.29 | 114.31 | 3667054.0 |
| 2010-03-08 15:00:00 | SPY | ETF | 114.31 | 114.36 | 114.24 | 114.359 | 5533966.0 |
| 2010-03-08 15:30:00 | SPY | ETF | 114.35 | 114.39 | 114.22 | 114.27 | 12849404.0 |
| 2010-03-08 16:00:00 | SPY | ETF | 114.27 | 114.38 | 114.14 | 114.21 | 4614413.0 |
| 2010-03-08 16:30:00 | SPY | ETF | 114.2 | 114.21 | 114.13 | 114.18 | 582107.0 |
| 2010-03-08 17:00:00 | SPY | ETF | 114.19 | 114.19 | 114.09 | 114.13 | 35495.0 |
| 2010-03-08 17:30:00 | SPY | ETF | 114.13 | 114.13 | 114.09 | 114.1 | 20252.0 |
| 2010-03-08 18:00:00 | SPY | ETF | 114.09 | 114.13 | 114.09 | 114.1 | 19855.0 |
| 2010-03-08 18:30:00 | SPY | ETF | 114.09 | 114.09 | 114.06 | 114.07 | 32450.0 |
| 2010-03-08 19:00:00 | SPY | ETF | 114.06 | 114.06 | 113.99 | 114.05 | 28611.0 |
| 2010-03-08 19:30:00 | SPY | ETF | 114.05 | 114.05 | 113.99 | 114.04 | 25134.0 |
| 2010-03-08 04:30:00 | QQQ | ETF | 46.39 | 46.39 | 46.39 | 46.39 | 200.0 |
| 2010-03-08 07:00:00 | QQQ | ETF | 46.43 | 46.47 | 46.43 | 46.47 | 10850.0 |
| 2010-03-08 07:30:00 | QQQ | ETF | 46.46 | 46.47 | 46.44 | 46.46 | 27456.0 |
| 2010-03-08 08:00:00 | QQQ | ETF | 46.35 | 46.55 | 46.35 | 46.47 | 193292.0 |
| 2010-03-08 08:30:00 | QQQ | ETF | 46.48 | 46.5 | 46.42 | 46.44 | 158604.0 |
| 2010-03-08 09:00:00 | QQQ | ETF | 46.43 | 46.49 | 46.43 | 46.47 | 827004.0 |
| 2010-03-08 09:30:00 | QQQ | ETF | 46.46 | 46.56 | 46.44 | 46.47 | 9352150.0 |
| 2010-03-08 10:00:00 | QQQ | ETF | 46.47 | 46.58 | 46.45 | 46.51 | 4782859.0 |
| 2010-03-08 10:30:00 | QQQ | ETF | 46.52 | 46.6 | 46.47 | 46.58 | 3667518.0 |
| 2010-03-08 11:00:00 | QQQ | ETF | 46.58 | 46.6 | 46.47 | 46.48 | 3438786.0 |
| 2010-03-08 11:30:00 | QQQ | ETF | 46.49 | 46.56 | 46.46 | 46.53 | 2631304.0 |
| 2010-03-08 12:00:00 | QQQ | ETF | 46.53 | 46.59 | 46.5 | 46.58 | 2084977.0 |
| 2010-03-08 12:30:00 | QQQ | ETF | 46.58 | 46.59 | 46.52 | 46.58 | 1571252.0 |
| 2010-03-08 13:00:00 | QQQ | ETF | 46.5801 | 46.63 | 46.58 | 46.6101 | 2298986.0 |
| 2010-03-08 13:30:00 | QQQ | ETF | 46.612 | 46.64 | 46.6 | 46.63 | 2113445.0 |
| 2010-03-08 14:00:00 | QQQ | ETF | 46.63 | 46.64 | 46.55 | 46.56 | 6376030.0 |
| 2010-03-08 14:30:00 | QQQ | ETF | 46.56 | 46.6121 | 46.54 | 46.56 | 2424662.0 |
| 2010-03-08 15:00:00 | QQQ | ETF | 46.55 | 46.6 | 46.53 | 46.5724 | 2310085.0 |
| 2010-03-08 15:30:00 | QQQ | ETF | 46.57 | 46.62 | 46.52 | 46.53 | 5937742.0 |
> showing 50 of 8,328 rows — these rows as CSV