PREVIEW / etf_30min / 2022-03-11
file: by_date/etf_30min/2022/2022-03-11.parquet size: 668 KB rows: 26,482
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 |
|---|---|---|---|---|---|---|---|
| 2022-03-11 04:00:00 | SPY | ETF | 425.67 | 426.9 | 425.53 | 426.65 | 20990.0 |
| 2022-03-11 04:30:00 | SPY | ETF | 426.4 | 427.13 | 426.0 | 426.91 | 19780.0 |
| 2022-03-11 05:00:00 | SPY | ETF | 427.2 | 428.03 | 427.2 | 427.93 | 21917.0 |
| 2022-03-11 05:30:00 | SPY | ETF | 427.75 | 427.75 | 426.95 | 427.56 | 9160.0 |
| 2022-03-11 06:00:00 | SPY | ETF | 427.34 | 433.22 | 426.88 | 431.67 | 234925.0 |
| 2022-03-11 06:30:00 | SPY | ETF | 431.64 | 432.19 | 430.16 | 431.5 | 289963.0 |
| 2022-03-11 07:00:00 | SPY | ETF | 431.4 | 431.57 | 430.52 | 430.8 | 259819.0 |
| 2022-03-11 07:30:00 | SPY | ETF | 430.82 | 431.5 | 429.69 | 430.0 | 215691.0 |
| 2022-03-11 08:00:00 | SPY | ETF | 431.05 | 431.9104 | 424.88 | 430.0 | 469499.0 |
| 2022-03-11 08:30:00 | SPY | ETF | 430.01 | 430.2 | 428.73 | 428.81 | 385979.0 |
| 2022-03-11 09:00:00 | SPY | ETF | 428.91 | 429.17 | 428.11 | 428.13 | 421273.0 |
| 2022-03-11 09:30:00 | SPY | ETF | 428.12 | 428.77 | 426.57 | 427.125 | 8581083.0 |
| 2022-03-11 10:00:00 | SPY | ETF | 427.14 | 427.19 | 424.85 | 425.66 | 5809735.0 |
| 2022-03-11 10:30:00 | SPY | ETF | 425.66 | 427.0899 | 424.94 | 426.96 | 5069254.0 |
| 2022-03-11 11:00:00 | SPY | ETF | 426.97 | 427.03 | 425.1 | 425.23 | 4054827.0 |
| 2022-03-11 11:30:00 | SPY | ETF | 425.23 | 425.27 | 423.73 | 424.38 | 4407904.0 |
| 2022-03-11 12:00:00 | SPY | ETF | 424.38 | 424.82 | 423.38 | 423.47 | 3745708.0 |
| 2022-03-11 12:30:00 | SPY | ETF | 423.45 | 424.33 | 423.0 | 424.005 | 3114627.0 |
| 2022-03-11 13:00:00 | SPY | ETF | 424.01 | 425.2 | 423.72 | 425.01 | 3057934.0 |
| 2022-03-11 13:30:00 | SPY | ETF | 424.99 | 425.52 | 423.65 | 423.68 | 2814030.0 |
| 2022-03-11 14:00:00 | SPY | ETF | 423.7 | 424.86 | 423.36 | 424.67 | 2925761.0 |
| 2022-03-11 14:30:00 | SPY | ETF | 424.675 | 424.8 | 422.605 | 423.1 | 4316143.0 |
| 2022-03-11 15:00:00 | SPY | ETF | 423.105 | 423.18 | 421.95 | 421.95 | 4004496.0 |
| 2022-03-11 15:30:00 | SPY | ETF | 421.95 | 421.95 | 419.53 | 420.08 | 15347946.0 |
| 2022-03-11 16:00:00 | SPY | ETF | 420.08 | 420.6 | 419.87 | 420.56 | 5191366.0 |
| 2022-03-11 16:30:00 | SPY | ETF | 420.51 | 420.74 | 420.07 | 420.2201 | 207556.0 |
| 2022-03-11 17:00:00 | SPY | ETF | 420.35 | 420.35 | 420.1 | 420.24 | 72511.0 |
| 2022-03-11 17:30:00 | SPY | ETF | 420.22 | 420.27 | 420.03 | 420.05 | 41609.0 |
| 2022-03-11 18:00:00 | SPY | ETF | 420.05 | 420.1 | 419.84 | 419.84 | 41479.0 |
| 2022-03-11 18:30:00 | SPY | ETF | 419.82 | 420.1 | 419.75 | 420.0 | 30749.0 |
| 2022-03-11 19:00:00 | SPY | ETF | 420.06 | 420.35 | 420.0 | 420.05 | 16091.0 |
| 2022-03-11 19:30:00 | SPY | ETF | 420.03 | 420.05 | 419.81 | 419.95 | 14835.0 |
| 2022-03-11 04:00:00 | QQQ | ETF | 330.72 | 332.63 | 330.72 | 332.17 | 33895.0 |
| 2022-03-11 04:30:00 | QQQ | ETF | 332.31 | 333.0 | 332.0 | 332.81 | 19907.0 |
| 2022-03-11 05:00:00 | QQQ | ETF | 332.79 | 333.63 | 332.78 | 333.4 | 26900.0 |
| 2022-03-11 05:30:00 | QQQ | ETF | 333.42 | 333.42 | 332.58 | 333.02 | 125789.0 |
| 2022-03-11 06:00:00 | QQQ | ETF | 332.96 | 338.0 | 332.2 | 336.7 | 267959.0 |
| 2022-03-11 06:30:00 | QQQ | ETF | 336.54 | 337.57 | 335.85 | 336.86 | 235650.0 |
| 2022-03-11 07:00:00 | QQQ | ETF | 336.81 | 336.98 | 335.93 | 336.57 | 242091.0 |
| 2022-03-11 07:30:00 | QQQ | ETF | 336.66 | 337.11 | 335.55 | 335.81 | 255669.0 |
| 2022-03-11 08:00:00 | QQQ | ETF | 336.5692 | 337.4004 | 328.9 | 335.76 | 440774.0 |
| 2022-03-11 08:30:00 | QQQ | ETF | 335.91 | 335.91 | 334.88 | 335.0 | 195605.0 |
| 2022-03-11 09:00:00 | QQQ | ETF | 335.03 | 335.38 | 334.29 | 334.32 | 250139.0 |
| 2022-03-11 09:30:00 | QQQ | ETF | 334.32 | 334.64 | 330.99 | 331.5192 | 7196550.0 |
| 2022-03-11 10:00:00 | QQQ | ETF | 331.5 | 331.5 | 329.35 | 330.0718 | 4313902.0 |
| 2022-03-11 10:30:00 | QQQ | ETF | 330.07 | 331.38 | 329.3803 | 330.98 | 3193105.0 |
| 2022-03-11 11:00:00 | QQQ | ETF | 330.98 | 331.07 | 328.51 | 328.5901 | 3603286.0 |
| 2022-03-11 11:30:00 | QQQ | ETF | 328.62 | 328.64 | 327.11 | 328.25 | 4439989.0 |
| 2022-03-11 12:00:00 | QQQ | ETF | 328.24 | 328.8 | 327.255 | 327.3 | 2731523.0 |
| 2022-03-11 12:30:00 | QQQ | ETF | 327.31 | 328.19 | 326.8599 | 327.97 | 2013804.0 |
> showing 50 of 26,482 rows — these rows as CSV