PREVIEW / etf_30min / 2015-08-10
file: by_date/etf_30min/2015/2015-08-10.parquet size: 380 KB rows: 12,763
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 |
|---|---|---|---|---|---|---|---|
| 2015-08-10 04:00:00 | SPY | ETF | 208.21 | 208.29 | 208.21 | 208.23 | 1156.0 |
| 2015-08-10 04:30:00 | SPY | ETF | 208.31 | 208.6 | 208.31 | 208.6 | 3855.0 |
| 2015-08-10 05:00:00 | SPY | ETF | 208.55 | 208.64 | 208.43 | 208.45 | 15364.0 |
| 2015-08-10 05:30:00 | SPY | ETF | 208.45 | 208.6 | 208.43 | 208.52 | 13570.0 |
| 2015-08-10 06:00:00 | SPY | ETF | 208.44 | 208.62 | 208.42 | 208.5 | 6408.0 |
| 2015-08-10 06:30:00 | SPY | ETF | 208.66 | 208.73 | 208.6 | 208.62 | 7349.0 |
| 2015-08-10 07:00:00 | SPY | ETF | 208.58 | 209.02 | 208.58 | 208.92 | 119842.0 |
| 2015-08-10 07:30:00 | SPY | ETF | 208.88 | 208.95 | 208.78 | 208.85 | 174842.0 |
| 2015-08-10 08:00:00 | SPY | ETF | 208.84 | 209.49 | 208.6 | 209.4 | 634950.0 |
| 2015-08-10 08:30:00 | SPY | ETF | 209.39 | 209.54 | 209.34 | 209.35 | 513850.0 |
| 2015-08-10 09:00:00 | SPY | ETF | 209.35 | 209.44 | 208.0123 | 209.28 | 514462.0 |
| 2015-08-10 09:30:00 | SPY | ETF | 209.28 | 210.09 | 209.28 | 209.865 | 14276866.0 |
| 2015-08-10 10:00:00 | SPY | ETF | 209.865 | 210.14 | 209.77 | 209.99 | 6502489.0 |
| 2015-08-10 10:30:00 | SPY | ETF | 209.995 | 210.08 | 209.75 | 210.02 | 4942466.0 |
| 2015-08-10 11:00:00 | SPY | ETF | 210.02 | 210.31 | 210.02 | 210.09 | 6003677.0 |
| 2015-08-10 11:30:00 | SPY | ETF | 210.1 | 210.33 | 210.1 | 210.185 | 3989376.0 |
| 2015-08-10 12:00:00 | SPY | ETF | 210.195 | 210.32 | 210.17 | 210.27 | 2646948.0 |
| 2015-08-10 12:30:00 | SPY | ETF | 210.2767 | 210.37 | 210.22 | 210.335 | 2323472.0 |
| 2015-08-10 13:00:00 | SPY | ETF | 210.335 | 210.475 | 210.29 | 210.36 | 2240683.0 |
| 2015-08-10 13:30:00 | SPY | ETF | 210.36 | 210.46 | 210.36 | 210.455 | 2551976.0 |
| 2015-08-10 14:00:00 | SPY | ETF | 210.46 | 210.67 | 210.37 | 210.5347 | 3945658.0 |
| 2015-08-10 14:30:00 | SPY | ETF | 210.535 | 210.54 | 210.42 | 210.47 | 3498992.0 |
| 2015-08-10 15:00:00 | SPY | ETF | 210.465 | 210.55 | 210.42 | 210.43 | 4372553.0 |
| 2015-08-10 15:30:00 | SPY | ETF | 210.43 | 210.59 | 210.3 | 210.58 | 12156050.0 |
| 2015-08-10 16:00:00 | SPY | ETF | 210.58 | 210.71 | 210.2744 | 210.55 | 4539942.0 |
| 2015-08-10 16:30:00 | SPY | ETF | 210.52 | 210.71 | 210.17 | 210.66 | 1194162.0 |
| 2015-08-10 17:00:00 | SPY | ETF | 210.67 | 210.7 | 210.57 | 210.69 | 225155.0 |
| 2015-08-10 17:30:00 | SPY | ETF | 210.67 | 210.73 | 210.67 | 210.69 | 22139.0 |
| 2015-08-10 18:00:00 | SPY | ETF | 210.68 | 210.8 | 210.65 | 210.66 | 44414.0 |
| 2015-08-10 18:30:00 | SPY | ETF | 210.68 | 210.68 | 210.57 | 210.62 | 485159.0 |
| 2015-08-10 19:00:00 | SPY | ETF | 210.65 | 210.65 | 210.6 | 210.63 | 17396.0 |
| 2015-08-10 19:30:00 | SPY | ETF | 210.61 | 210.68 | 210.61 | 210.68 | 23625.0 |
| 2015-08-10 07:00:00 | QQQ | ETF | 110.62 | 110.75 | 110.62 | 110.72 | 2400.0 |
| 2015-08-10 07:30:00 | QQQ | ETF | 110.78 | 110.81 | 110.77 | 110.77 | 34100.0 |
| 2015-08-10 08:00:00 | QQQ | ETF | 110.76 | 111.03 | 110.76 | 111.03 | 124757.0 |
| 2015-08-10 08:30:00 | QQQ | ETF | 111.04 | 111.09 | 110.99 | 111.01 | 36444.0 |
| 2015-08-10 09:00:00 | QQQ | ETF | 110.99 | 111.04 | 110.96 | 111.0 | 61053.0 |
| 2015-08-10 09:30:00 | QQQ | ETF | 111.01 | 111.64 | 111.0 | 111.34 | 4350730.0 |
| 2015-08-10 10:00:00 | QQQ | ETF | 111.35 | 111.5 | 111.31 | 111.32 | 2141497.0 |
| 2015-08-10 10:30:00 | QQQ | ETF | 111.32 | 111.33 | 111.08 | 111.23 | 1541265.0 |
| 2015-08-10 11:00:00 | QQQ | ETF | 111.24 | 111.4408 | 111.2343 | 111.33 | 1048849.0 |
| 2015-08-10 11:30:00 | QQQ | ETF | 111.33 | 111.63 | 111.2506 | 111.5 | 1296080.0 |
| 2015-08-10 12:00:00 | QQQ | ETF | 111.5 | 111.58 | 111.463 | 111.48 | 704226.0 |
| 2015-08-10 12:30:00 | QQQ | ETF | 111.48 | 111.5593 | 111.41 | 111.4694 | 775923.0 |
| 2015-08-10 13:00:00 | QQQ | ETF | 111.47 | 111.57 | 111.46 | 111.5 | 426884.0 |
| 2015-08-10 13:30:00 | QQQ | ETF | 111.5 | 111.62 | 111.49 | 111.605 | 412881.0 |
| 2015-08-10 14:00:00 | QQQ | ETF | 111.6 | 111.81 | 111.53 | 111.71 | 1158027.0 |
| 2015-08-10 14:30:00 | QQQ | ETF | 111.71 | 111.76 | 111.55 | 111.5865 | 783453.0 |
| 2015-08-10 15:00:00 | QQQ | ETF | 111.59 | 111.6558 | 111.51 | 111.524 | 728728.0 |
| 2015-08-10 15:30:00 | QQQ | ETF | 111.52 | 111.56 | 111.41 | 111.56 | 2579582.0 |
> showing 50 of 12,763 rows — these rows as CSV